How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze

Posted by falko on May 11, 2012 2:52 PM EDT
HowtoForge; By Falko Timme
Mail this story
Print this story

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.

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

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: Debian, MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.