[Re]Encoded.com

The (Free) Script That Saved My Website

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.com. 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.

Related posts:

1. Website Sale Gone Wrong Part II So today I finally found out what guy who is...
2. Tips for having a professional Website Having a good website up and running can be a...
3. Learning Web Design: 5 New Free CSS Website Templates This post is specially for web design beginners to provide...
4. Save on Bandwidth! Save on Bandwidth! Paying close attention to your bandwidth really...
5. A Useful Addition to any Business Website I’ve used this code in a large amount of business...