Here’s an interesting script, something that I’ve been searching for for awhile: Automatic MySQL Backup. What does it do?
Everyday AutoMySQLBackup will run (if setup on /etc/cron.daily) and using mysqldump and gzip will dump your specified databases to the /backups/daily directory, it will rotate daily backups weekly so you should never have more than 7 backups in there.
Every Saturday AutoMySQLBackup will again backup the databases you have chosen but they will be placed into /backups/weekly, these will be rotated every 5 weeks so there should never be more than 5 backups in there.
For those of us who use a blogging package that uses a MySQL back-end, this is an ultra-cool utility. It’s much more convenient than using WordPress’s backup plugin, since it requires no further user intervention once it is configured and added to cron.
