MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. MySQL Backup for lazy sysadmins program was written with automated usage in mind.
For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).
Installation:
Simply drop the script where you want it to be and create a config file (usually $HOME/.mysqlblasyrc)
NOTE
This tool is only actively supported for Perl version > 5.8.3
Product's homepage
Here are some key features of "MySQL Backup for lazy sysadmins":
· syslog facility
· unix output (loglevels, errors to stderr)
· dump some or all databases from a database instance
· compress dumps (using gzip,bzip2 or perl modules)
· backup rotation to avoid disc overflow
· no shell on external commands!
· can be run as unpriviledged user
· perfect for cron jobs
Requirements:
· Perl
· MySQL
What's New in This Release: [ read full changelog ]
· Optional table optimization after dumping was added.
· Archive::ZIP is not required when running on Win32.