rsync
(On Windows, cwRsync)1. rsync on the master while it runs local.
2. Stop the master.
3. rsync a 2nd time to get a fast diff-sync.
4. Stop the slave.
5. rsync the master-backup to the slave.
6. Start replication.
Cold physical copy
If the versions and OSes are identical and all tables are InnoDB, a cold (physical copy) backup is reliable: Do a error-free server shutdown. Copy all ibdata files and .ibd files, .frm files for InnoDB tables, ib_logfile files, and my.cnf/ini to a safe place.Enterprise backup tool
If you have the Enterprise edition, Hot backup: Use the mysqlbackup tool in MySQL Enterprise Backup.LVM
On Linux systems LVM afteran error-free shutdown:https://www.lullabot.com/articles/mysql-backups-using-lvm-snapshots
Xtrabackup
XtraBackup from Percona: http://www.percona.com/doc/percona-xtrabackup/innobackupex/creating_a_backup_ibk.html
Last updated 26 Dec 2024
