Differences
This shows you the differences between two versions of the page.
Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
mysql:backup [2009/05/25 00:35] 127.0.0.1 external edit |
mysql:backup [2010/01/30 13:33] (current) a |
* [[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/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]] | * [[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 |