xtrabackup2.4 部分备份

环境  centos 7.2   mysql 5.7.20

xtrabackup -u root -p 000000 --backup --datadir=/usr/local/mysql/data  \
--target-dir=/data/backups/ --tables="^demo[.].*"

 

-- 单表
xtrabackup -u root -p 000000 --backup --datadir=/usr/local/mysql/data  \
--target-dir=/data/backups/ --tables="^demo[.]test"

-- 多表 
 xtrabackup -u root -p 000000 --backup --datadir=/usr/local/mysql/data  \
--target-dir=/data/backups/ --tables="^demo[.]test,test2"