#全备份
innobackupex --user=root --password=abc123 /u01/mysql/backup
#基于第一次全备份的增量备份1
innobackupex --user=root --password=abc123 --incremental /u01/mysql/backup --incremental-basedir=/u01/mysql/backup/2017-06-01_16-26-00
#基于增量备份1的增量备份2
innobackupex --user=root --password=abc123 --incremental /u01/mysql/backup --incremental-basedir=/u01/mysql/backup/2017-06-01_16-27-13
#将两次增量备份应用到第一次的全备份,注意查看第一次全备份下xtrabackup_checkpoints文件中 backup_type,from_lsn,to_lsn,last_lsn的变化
innobackupex --apply-log --redo-only /u01/mysql/backup/2017-06-01_16-26-00
innobackupex --apply-log --redo-only /u01/mysql/backup/2017-06-01_16-26-00 --incremental-dir=/u01/mysql/backup/2017-06-01_16-27-13
innobackupex --apply-log /u01/mysql/backup/2017-06-01_16-26-00 --incremental-dir=/u01/mysql/backup/2017-06-01_16-28-25
#恢复
innobackupex --copy-back /u01/mysql/backup/2017-06-01_16-26-00 #(apply-log)
物理备份恢复mariadb
于 2017-06-01 16:34:56 首次发布