How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
Posted on: 01/15/2013 04:07 PM
Howtoforge shows oyu how to backup MySQL databaes with mylvmbackup on Ubuntu 12.10
How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
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.