xtrabackup安装
vi /etc/yum.repos.d/Percona.repo
[percona]
name = CentOS $releasever - Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
enabled = 1
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
gpgcheck = 1
yum -y install percona-xtrabackup libaio libaio-devel
1、全备份
innobackupex --user=root --password=8812345 --host=192.168.11.125
--defaults-file=/etc/my.cnf --no-timestamp ./full
2、增量备份1
innobackupex --no-timestamp --incremental --incremental-basedir=./full ./inc1
3、增量备份2
innobackupex --no-timestamp --incremental --incremental-basedir=./inc1 ./inc2
恢复操作
innobackupex --apply-log --redo-only ./full
innobackupex --apply-log --redo-only ./full --incremental-dir=/root/test/inc1
innobackupex --apply-log --redo-only ./full --incremental-dir=/root/test/inc2
innobackupex --copy-back ./full
chown mysql.mysql /data/mysqldata -R
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23721637/viewspace-1058125/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23721637/viewspace-1058125/