February 22, 2010

Solving Large MySQL Imports

MySQL GUI Tools
Image via Wikipedia

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.

Now that that’s done, I can go back to looking through Disney vacations to see where we may be going on our next holiday. This was holding me up, but now that my MySQL restore is done, I have the evening to myself.

Comment Below ↓

There are no comments yet, be the first!

Leave a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • TweetRoll

  • Recent Comments

  • Enter your email address:

    Delivered by FeedBurner