Automatically Backup MySQL Databases!

This is for you MySQL users out there. This nifty script really helps with backing up your MySQL databases. It even has rotation and it can email you the backed up databases or just a log of what happened.

I currently use it on 4 of my servers and now that I’ve setup shared keys there’s a section in the script that allows you to run any command after the backup completes. My command tells the server to synchronize the fresh backups to another server for safe keeping, VERY COOL!!

To set it to run automatically you should be familiar with cronjobs. I just set the script to run every morning at 2am.

You can read more and download the script here.