Dumping big mySQL database
I’d a big problem to restore my large backup of my mySQL database as I wanted to restore this blog on this new server. I tried to import the dump using phpMyAdmin but it only dumped few lines of the backup (my backup files were about 11.5MB) due to hard memory resp. runtime limit of the web-server.
The script which really helped me is BigDump: Staggered MySQL Dump Importer. With this script you can dump database files created by phpMyAdmin .By the way GZip compressed dump files is also supported but only with PHP 4.3.0 and later. But it you are advised to use uncompressed dump since using a huge GZip compressed dump file can cause the script to exceed the PHP memory/runtime limit since the dump file has to be unpacked from the beginning every time the session starts.
If I’m not mistaken, you can ask your hosting provider to dump it for you.
Btw welcome back!
Best to dump locally using command line or a simple php script, then download via ftp, much more reliable and supports resuming.
Can you explain more about that? I don’t get the idea.