查看备份结果
[mysql@server ~]$ ll
total 12
drwxrwxr-x 6 mysql mysql 4096 Nov 13 18:28 db_full_20141103
drwxrwxr-x 6 mysql mysql 4096 Nov 13 18:32 db_full_20141113-incr1
drwxrwxr-x 6 mysql mysql 4096 Nov 13 18:33 db_full_20141113-incr2
1 查看全备的lsn
[mysql@server ~]$ cat db_full_20141103/xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 2081824
last_lsn = 2081824
compact = 0
2 查看增备1的lsn
[mysql@server ~]$ cat db_full_20141113-incr1/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 2081824
to_lsn = 2117817
last_lsn = 2117817
compact = 0
3 查看增备2的lsn
[mysql@server ~]$ cat db_full_20141113-incr2/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 2117817
to_lsn = 2146660
last_lsn = 2146660
compact = 0
Mysql热备增量备份与恢复(二)--备份部分查看
最新推荐文章于 2022-03-17 20:40:48 发布