Phoenix Network Forums

I'm moving an site to an new server. The SQL dump for that site is rather large (about 100MB), so I can't execute it from my PC cause it would timeout. The problem is that the new hostig doesn't offer an shell login.
Now my question is, can I use this shell in some way to get the SQl dump on the other hosting?

I know of a php script that can DEFINITELY help you upload that whole database to a new MySQL database without timing out. It's called BigDump.

http://www.ozerov.de/bigdump.php

Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web-servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

So, it will upload that whole file for you. No shell required. Just PHP and MySQL

Nintendud wrote:So, it will upload that whole file for you. No shell required. Just PHP and MySQL

Thnx, I'll try this out

Tell me how it goes. This simple file has helped out me and many other people who I've recommended it to. I think it should be a standard feature of PHPMyAdmin. Seriously, most everyone who has a forum will eventually end up with a huge .sql backup. It's sad that many don't know of this great tool which will easily restore their database if they ever need to.

Yep, it worked very good for me. I was allready working on creating my own script for this, but well, this goes much faster

You have no luck,aren`t ya ?:D