BigDump is awesome
I have been trying to restore a MySQL database for several days. The database is fairly large (130M), and so my server complains whenever I try to upload it through phpMyAdmin. I have also tried just copying/pasting sections of the MySQL database into the SQL Query area, but doing that with a large database is about as fun as rubbing your eyeballs with sandpaper. Something always goes wrong when you upload chunks manually.
After doing some research, I came across BigDump. When you use BigDump to upload/restore a database, it only restores so many lines of mysql at a time so that the server never gets overloaded or times out. I could not believe how fast it had finished the job. It seemed like 2 minutes max. I had spent hours trying to get it to work before then.
To use BigDump, all you have to do is upload the file to your site. Its just a file called, bigdump.php. Then, enter in your database information and where your backup is located( you will have to upload your .sql file via FTP to your site ) and then click the start button. Its so simple. I highly recommend it for those of you out there that are having the same problems that I was.