andyisaacson

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.

Check out the new design for Calypsos Coffee. The Calypsos Coffee site is run off of Wordpress. I’m enjoying building Wordpress driven sites more and more. Wordpress is designed completely using CSS/XHTML which makes it really easy for designers like myself to create a totally original website and offer a powerful CMS to my clients.