MySQL Backup for lazy sysadmins 0.7 review

MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups

License: GPL (GNU General Public License) File size: 18K Developer: Paul Kremer

0

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

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 5.6.1 (and some modules)
MySQL

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

What's New in This Release:
The "defaults-extra-file" config option was added, which can be used instead of specifying the username/password/host directly in the config file.
The "dbhost" config paramater is now also used for the backup filename.
If you use the new "defaults-extra-file" for remote backups, this key is still needed to set the filename.
Code formatting and minor fixes were done.