Differences
This shows you the differences between two versions of the page.
Next revision
|
Previous revision
|
mysql:backup [2008/10/28 17:24] a NEED TO BE FIXED |
mysql:backup [2010/01/30 13:33] (current) a |
* http://www.maatkit.org/doc/mk-parallel-restore.html | * http://www.maatkit.org/doc/mk-parallel-restore.html |
* http://www.maatkit.org/doc/mk-parallel-dump.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 |