xtrabackup: Error: cannot open /../../base/xtrabackup_checkpoints

urgel_babay發表於2016-02-29
 2014.10.22
       昨天在做MySQL 5.6 xtrabackup 增量備份測試的時候,遇見下面的錯誤,搞了大半個下午都沒與解決,度娘也沒有給出解決方案,問了大牛,也沒給出。
今天早上到公司,去到官網,把官方的文件看了一篇,還好看得懂英文的,這才解決了。
[root@BIDEVEDW_DB bin]# ./xtrabackup --backup --log-stream --target-dir=/mysqlbak/xtrabackup/delta --incremental-basedir=/mysqlbak/xtrabackup/base
xtrabackup: Error: cannot open /mysqlbak/xtrabackup/base/xtrabackup_checkpoints
xtrabackup: error: failed to read metadata from /mysqlbak/xtrabackup/base/xtrabackup_checkpoints

這是全量備份的命令:
./xtrabackup --backup --log-stream --target-dir=/mysqlbak/xtrabackup/20141022 --datadir=/usr/local/mysql/data

1、在做增量備份的時候,如果--target-dir跟全量的一樣,就會出現下面的報錯
[root@zhanglin bin]# ./xtrabackup --backup --log-stream --target-dir=/mysqlbak/xtrabackup/20141022 --datadir=/usr/local/mysql/data --incremental-basedir=/mysqlbak/xtrabackup/20141022_full_in
xtrabackup: Error: cannot open /mysqlbak/xtrabackup/20141022_full_in/xtrabackup_checkpoints
xtrabackup: error: failed to read metadata from /mysqlbak/xtrabackup/20141022_full_in/xtrabackup_checkpoints

2、 如果--incremental-basedir= 引數的最後目錄不是base也會出錯。
[root@zhanglin bin]# ./xtrabackup --backup --log-stream --target-dir=/mysqlbak/xtrabackup/20141022_full_in --datadir=/usr/local/mysql/data --incremental-basedir=/mysqlbak/xtrabackup/20141022-test
xtrabackup: Error: cannot open /mysqlbak/xtrabackup/20141022-test/xtrabackup_checkpoints
xtrabackup: error: failed to read metadata from /mysqlbak/xtrabackup/20141022-test/xtrabackup_checkpoints


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30936525/viewspace-2016605/,如需轉載,請註明出處,否則將追究法律責任。

相關文章