Photo Credit:
GoDaddy.com
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. Read more »