Problems restoring a large MySQL database?

Squeeeeze! (Lemon Grenade)
Creative Commons License photo credit: onkel_wart

I had a bit of a problem today trying to get an 8Mb backup uploaded into MySQL. The problem was caused by the fact that phpMyAdmin was timing out when I tried to import the database. I tried breaking it down into smaller sections but a couple of the tables just had too many rows in them. Just as I was about to bang my head against the wall, I came across BigDump, a MySQL upload tool that staggers the uploads allowing you to upload dump files up to 50Mb in size.

One to add to the toolbox!

Do you have any MySQL tools you’d like to share?

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.