Need To Import Large MYSQL Database to GoDaddy? I have a Solution for their File Size Limitation.

If you follow me on Twitter, you've no doubt heard my rants about GoDaddy's service. Let's face it, the only thing they're good at is marketing.

However, this post is not about GoDaddy's service, it's about a much needed workaround for their MYSQL Database limitation. They limit the file size of your database to be imported to 1,024 MiB. If I had a database that small, I would type it in manually. If you're working on transferring your existing CMS (e.g., Drupal, Wordpress, or Joomla) Godaddy recommends to upload the database via FTP and restore it as a backup. Although it has worked for me in the past, it failed yesterday. I received a "pending restore" message for hours and when I woke up this morning to check the status, it reported that the database was restored. I checked the tables in MyAdmin only to find the database completely empty.

The solution is BigDump: Staggered MySQL Dump Importer. I've used this in the past and it has never failed.

Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x dumps) even through the web servers with hard runtime limit and those in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.

http://www.ozerov.de/bigdump/

Donate to BigDump