The (Free) Script That Saved My Website

August 9th, 2008 Posted in Shortcuts, Various

I recently purchased a music streaming website, powered by MySQL database full of links to the musical content. In order to transfer the website to my hosting I was going to need to import the database. Unfortunately, I host with GoDaddy offers phpMyAdmin to control your databases which is a great program but it limits imports to 2MBs. My database was over 70MB. I tried it anyways with my fingers crossed but as expected, it wasn’t going to work.

Next, I remembered Navicat, a program that allows you to externally monitor your database and has no limit on the file you can upload. To use Navicat, you need the standard database info (username, password, databasename) and the external IP address to the server the database is on. I called up the GoDaddy support and explained my situation. My customer service associate quickly (and rudely) explained that GoDaddy does not allow an external connection to their database servers at any time. This is their (stone age) approach to protecting their servers. Other hosting companies seem to do fine relying on other methods for security while still allowing customers to connect to their servers but GoDaddy does not share the same philosophy.

I was out of luck. I decided to just break up the file manually into over 35 pieces and uploaded one by one, a task that would take quite a good deal of time. However, my database was too large to open in notepad even on my quad core behemoth. Totally crushed, I took one last ditch look around the internet. That’s when I cam across BigDump.

BigDump is a script written by Alexey Ozerov that automatically cuts your database into pieces and uploads them one by one. The setup is simple and the operation was flawless. I was elated, my money wouldn’t be going down the drain after all. If you haven’t already heard of BigDump check it out. You may not need it now, but it could save your website in the future as it did for me.

If you already know about BigDump, as I’m sure many of you do, has it ever saved your site? If you’re just now learning about BigDump, keep it in mind in case you ever need it.

Author -

who has written 16 posts on [Re]

Contact the author

3 Responses to “The (Free) Script That Saved My Website”

  1. haley Says:

    i love BigDump. it saved my life

  2. Harish Says:

    I had used this script few months ago, to move a customers database to GoDaddy. After speaking with GoDaddy, I had found its link in some forum post.

Leave a Reply