How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze

falko's picture

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on a Debian Squeeze server.

http://www.howtoforge.com/how-to-back-up-mysql-databases-with-mylvmbackup-on-debian-squeeze