MySQL

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
FIXME FIXME FIXME

   * http://www.maatkit.org/
   * http://www.maatkit.org/doc/mk-parallel-restore.html
   * http://www.maatkit.org/doc/mk-parallel-dump.html
   * [[http://www.howtoforge.com/how-to-back-up-mysql-databases-with-mylvmbackup-on-ubuntu-8.10|How To Back Up MySQL Databases With mylvmbackup]]
   * [[http://www.howtoforge.com/linux_lvm_snapshots|Back Up (And Restore) LVM Partitions With LVM Snapshots]]

===== How To Back Up MySQL Databases With mylvmbackup =====

   * [[http://lenz.homelinux.org/mylvmbackup/ 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


A sample command for backing up MyISAM tables would be:

   mylvmbackup --user=root --password=yourrootsqlpassword --mycnf=/etc/mysql/my.cnf --vgname=server1 --lvname=mysql --backuptype=tar 

And for InnoDB:

   mylvmbackup --user=root --password=yourrootsqlpassword --innodb_recover --skip_flush_tables --mycnf=/etc/mysql/my.cnf --vgname=server1 --lvname=mysql --backuptype=tar