xtrabackup备份

增量备份:xtrabackup –backup –target-dir=/data/backup/base –datadir=/var/lib/mysqlxtrabackup –backup –target-dir=/data/backup/inc –incremental-basedir=/data/backup/base/ –datadir=/var/lib/mysqlxtrabackup –backup –target-dir=/data/b

增量备份:
xtrabackup –backup –target-dir=/data/backup/base –datadir=/var/lib/mysql
xtrabackup –backup –target-dir=/data/backup/inc –incremental-basedir=/data/backup/base/ –datadir=/var/lib/mysql
xtrabackup –backup –target-dir=/data/backup/inc2 –incremental-basedir=/data/backup/inc –datadir=/var/lib/mysql

增量恢复:
xtrabackup –prepare –apply-log-only –target-dir=/data/backup/base
xtrabackup –prepare –apply-log-only –target-dir=/data/backup/base/ –incremental-dir=/data/backup/inc
xtrabackup –prepare –target-dir=/data/backup/base/ –incremental-dir=/data/backup/inc2
注意:–apply-log-only 应该用于合并除了最后一次之外的所有增量备份。

还原:关闭mysql,直接copy,然后修改权限再启动
局部备份:
To back up only tables in the test database,you can use the following command:
xtrabackup –backup –datadir=/var/lib/mysql –target-dir=/data/backups –tables=”^test[.].*”
xtrabackup –backup –datadir=/var/lib/mysql –target-dir=/data/backups –tables=”^test[.]t1″

作者: dawei

【声明】:永州站长网内容转载自互联网,其相关言论仅代表作者个人观点绝非权威,不代表本站立场。如您发现内容存在版权问题,请提交相关链接至邮箱:bqsm@foxmail.com,我们将及时予以处理。

为您推荐

联系我们

联系我们

0577-28828765

在线咨询: QQ交谈

邮箱: xwei067@foxmail.com

工作时间:周一至周五,9:00-17:30,节假日休息

返回顶部