meissenation
12-28-2006, 11:09 AM
I just wanted to throw a little review up for the BigDump.php file (google it, you'll find it), it's an amazingly easy to use file to import database files.
I just recently switched servers, and my database is about 1 gig (darn attachments!). I couldn't just download a backup from cpanel and then upload due to timeouts. I couldn't import into phpMyAdmin because of the 51mb restrictions. Then I found BigDump.php.
You simply edit the file so it can connect to your database, upload it to a seperate directory, then grab the .sql or .sql.gz files from phpMyAdmin's Export feature. Upload it to the new server via FTP in the same directory as BigDump.php and then open BigDump.php. It'll list all .sql and .sql.gz files and then process each file, only processing 3000 lines at a time, then waiting x milliseconds (in my case, 3000) before processing the next 3000 lines. No timeouts!
The only stipulation is that I personally had to SSH into my server and change the global max_packet_allowed for the mysql connections because the attachment table kept going over the limit. Once that was set, the database went flawlessly easy! I had to download table backups for attachment, vbpicgallery_images, and vbhotornot_photos first, then I downloaded a backup of all the rest of the tables in one .sql.gz file. I uploaded it to the server, pressed Start Import and went off to work. When I returned home, I was greeted with the "Finished import, end of file reached." and it was all done. :D
Just wanted to throw a review up, this file saved me enough time that I figured I could take the time to write some good remarks about it. :D
I just recently switched servers, and my database is about 1 gig (darn attachments!). I couldn't just download a backup from cpanel and then upload due to timeouts. I couldn't import into phpMyAdmin because of the 51mb restrictions. Then I found BigDump.php.
You simply edit the file so it can connect to your database, upload it to a seperate directory, then grab the .sql or .sql.gz files from phpMyAdmin's Export feature. Upload it to the new server via FTP in the same directory as BigDump.php and then open BigDump.php. It'll list all .sql and .sql.gz files and then process each file, only processing 3000 lines at a time, then waiting x milliseconds (in my case, 3000) before processing the next 3000 lines. No timeouts!
The only stipulation is that I personally had to SSH into my server and change the global max_packet_allowed for the mysql connections because the attachment table kept going over the limit. Once that was set, the database went flawlessly easy! I had to download table backups for attachment, vbpicgallery_images, and vbhotornot_photos first, then I downloaded a backup of all the rest of the tables in one .sql.gz file. I uploaded it to the server, pressed Start Import and went off to work. When I returned home, I was greeted with the "Finished import, end of file reached." and it was all done. :D
Just wanted to throw a review up, this file saved me enough time that I figured I could take the time to write some good remarks about it. :D