Differences
This shows you the differences between two versions of the page.
| Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
mysql:backup [2008/12/27 19:36]
a |
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 |
