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