xtrabackup 備份mysql

1）安裝:  http://www.percona.com/downloads/   下載下傳 Percona XtraBackup

2）wget https://www.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.13/binary/tarball/percona-xtrabackup-2.4.13-Linux-x86_64.libgcrypt11.tar.gz

3）tar -zxvf percona-xtrabackup-2.4.13-Linux-x86_64.libgcrypt11.tar.gz

4）cd percona-xtrabackup-2.4.13-Linux-x86_64/bin/

5) 

cp innobackupex /usr/bin/innobackupex

cp xtrabackup /usr/bin/xtrabackup

[[email protected] bin]# xtrabackup -v

xtrabackup: recognized server arguments: --datadir=/home/mysql 

xtrabackup version 2.4.13 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 3e7ca7c)

6) 備份資料庫

innobackupex  --defaults-file=/etc/my.cnf --user=root --password=123456 --host=127.0.0.1  --databases=test  /home/test/xtrabackup/