A complex command-line Perl script for creating backup archives of MySQL databases
How mylvmbackup works? It automatically gets a read lock on all database tables, flushes all server caches to a disk drive, creates a LVM (Logical Volume Manager) snapshot of the volume that contains the MySQL data directory, and unlocks the database tables.
Besides Perl (Practical Extraction and Report Language), users will also need to install the DBD::mysql and DBI modules in order to properly use the mylvmbackup script. Additionally, the script also uses the /bin/date, tar, LVM utilities, and the mount and umount system utilities.
In a hurry? Add it to your Download Basket!
What's New in This Release:
- Improved error handling: send out an email if mail_report_on has been set to "errors" and a log message with log level LOG_ERR was logged.
- Abort and clean up if the snapshot volume could not be mounted
- Abort and clean up if the backup creation failed
- Exit with a non-zero return code if errorstate was set