Given how frequently I tinker with different web-based app installs (WordPress, drupal, Magento, etc.), I’ve always found it a bit of a pain to regularly backup the databases for those installations. Of course, however painful it may be, it’s always worth it in the event of a disaster!
I’ve found many MySQL backup solutions but none of them seem to be perfect in my eyes. (Hey, what is perfect these days?)
DESKTOP APPS
There’s Backup Watcher for MySQL but a) it costs $$ and b) you have to “activate” the software in order to use it. For someone like myself – who is constantly reformatting the various machines on which I work – that’s far too annoying given that you have to wait for a new activation code from the company. Of course, if you’re just gonna set this up on a server or desktop that you touch maybe once every three years – it may very well be worth it. Setting up automated backups is fool-proof and the interface isn’t too archaic. Plus, support usually responds within one business day – even if they aren’t that fluent in the English language.
One benefit to the above app is that it runs on Windows. For me, at least, that makes administration much easier. Another such app is Auto Backup for MySQL. (I’ll try and download and install this to post a review here soon.) This one also costs money (still less than $100) but the fact that it appears to be continually updated – it’s now Windows 7 and Server 2008 compatible – puts my mind at ease.
For more advanced MySQL DB management, you might also look at Navicat for MySQL – an all-in-one mgmt app that not only enables scheduled database backups but also provides you with options to interact with the data itself as well as the overall structure of the database. Pricing is much better than I remember. You can probably stay close to the price-range of the apps mentioned above and wind up with many more features at the same time. Plus, the interface is quite a bit more polished than the other apps.
WEB-BASED SCRIPTS
A more universal option (for those on different platforms beyond Windows) is a self-install script like Backup2Mail… which costs absolutely nothing. (The song “Born Free” from the last episode of the first season of Dexter is now running through my mind.)
Scripts like this one reside on your server, alongside your MySQL install, and regularly emails you backups of your database(s). The company recommends that you use a secure email environment given the risk involved in sending potentially-confidential data through email.
AutoMySQLBackup is a free script that’s been around for a while. Much like Backup2Mail, this script enables scheduled backups via the web but, with this one, you can not only send backups by email but also dump them to a directory on your web server. That way, if you’ve got the available space, you never need worry about the size of your DB backups.
What backup solution are you using/do you recommend? Let other readers know in the comments below.
