首页 MySql xtrabackup备份

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″

本文来自网络,不代表云浮站长网立场。转载请注明出处: https://www.0766zz.com/html/shujuku/mysql/20200905/9924.html
上一篇
下一篇

作者: dawei

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

为您推荐

返回顶部