Cool mySQLdatabase import tool: BigDump

Okay, so maybe everyone else has heard of this, but, it saved my sanity this week.

The Centers for Quality Teaching and Learning has been having some problems with their Moodle Site recently, so, we thought we might investigate whether or not it's our hosting company (have a sneaking suspicion it is). The long and short of it is that we've set up a site at another host and it was decided that I'd move Moodle over and give it a try.

Moving Moodle was relatively easy, except for the database. This hosting company doesn't give command line access, and phpMyAdmin was really not liking the 27 MB database I was trying to get it to import.

Enter BigDump. This cool little script takes the database dump file and breaks it up into chunks so that it loads the entire database dmp file with no problems. I have to say I've done this manually through phpMyAdmin before, but, this was a lifesaver.

Just wanted to post this here so it could save someone else's day too!

 
Trackbacks
  • No trackbacks exist for this entry.
Comments

  • 7/19/2006 4:21 PM Stephen Phillips wrote:
    Hey there! I just stumbled across your site and really like it. I think you might be interested in "logmein free". it's a remote access program that lets you access your home pc from work or vice versa - really great if you forget to print out a paper or something. just log into your home computer and email it to yourself!
    Reply to this
Leave a comment

Submitted comments will be subject to moderation before being displayed.

 Enter the above security code (required)

 Name

 Email (will not be published)

 Website

Your comment is 0 characters limited to 3000 characters.