How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10

77

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 an Ubuntu 12.10 server.

I do not issue any guarantee that this will work for you!

1 Preliminary Note

I’m assuming that MySQL is already set up and running on your system. The system must use LVM, and the MySQL data directory (/var/lib/mysql) should have an LVM partition of its own (although that is optional)….Read more at HowtoForge