mylvmbackup is a Perl script for quickly creating backups of a MySQL server’s data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds.
License: GNU General Public License (GPL)
Changes:
A bug in the InnoDB recovery function has been fixed: the second mysqld process clobbered the socket file of the primary MySQL instance. This release uses the correct mysqld parameter to provide an alternative PID file (–pid-file instead of –pidfile). An option “–skip_mycnf” has been added to skip including a copy of the MySQL configuration file in the backup. A safety check that the file actually exists prior to backing it up has been added.