xtrabackup: Error: cannot open /../../base/xtrabackup_checkpoints
昨天在做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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- error while loading shared libraries: libstdc++.so.5: cannot openErrorWhileC++
- [ERROR] Failed to open logErrorAI
- error while loading shared libraries: libcap.so.1: cannot open sharedErrorWhile
- LINK : fatal error LNK1104: cannot open file 'mfcs42d.lib'Error
- error while loading shared libraries: libgsl.so.27: cannot open shared objectErrorWhileObject
- 解決“su: cannot open session: Permission denied”Session
- virt-manager cannot open display問題
- Uncaught Error: Cannot instantiate interfaceError
- ‘error: ‘‘this‘‘ cannot be implicitly captured in this context‘ErrorAPTContext
- Failed to load libGL.so error libGL.so: cannot open shared object file: No such file or directoryAIErrorObject
- error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No suchErrorWhileIBMMySqlclientObject
- -bash: ulimit: open files: cannot modify limit: Operation not permittedMIT
- Fatal error: Cannot redeclare printerror() (previously declared in …Error
- PXC5.7WSREP_SST:[ERROR]xtrabackup_checkpointsmissingError
- Xtrabackup恢復時報錯'Error: datadir must be specified'Error
- innobackupex:Error:xtrabackup child process has died at /usr/bin/innobackupexError
- ERROR: Cannot uninstall ‘PyYAML‘. It is a distutils installed project and thus we cannot accuratelyErrorYAMLProject
- ERROR: UTL_SMTP.OPEN_CONNECTIONError
- Error while loading shared libraries: libreadline.so.7: cannot open shared objecErrorWhileOBJ
- error while loading shared libraries: libodm9.so: cannot open shared object file: No such file or diErrorWhileObject
- xtrabackup:error:streaming incremental backups are incompatible with the tarErrorREM
- “no source“: Error: #5: cannot open source input file “C:\Users\xxx\AppData\Local\Temp\p4228: PermiErrorAPP
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- RH5 安裝ORACLE 10G 出錯 1,libXp.so.6: cannot open 2,libXt.so.6: cannot openH5Oracle 10g
- VFS: Cannot open root device “nfs“ or unknown-block(2,0): error -6 NFS掛載不上,核心配置問題devNFSBloCError
- Import Error: cannot import name ‘export_saved_modelImportErrorExport
- Cannot retrieve repository metadata (repomd.xml) for repository: baseXML
- 12C-ORA-65086: cannot open/close the pluggable databaseDatabase
- rpm: error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such fi...ErrorWhileGCObject
- ./XXX.XX: error while loading shared libraries: libGLEW.so.2.1: cannot open shared object file: NoErrorWhileObject
- ORA-15186: ASMLIB error function = [asm_open], error = [1]ASMErrorFunction
- O/S-Error: (OS 33) The process cannot access the fileError
- error while loading shared libraries: libpython3.7m(2.7).so.1.0: cannot open shared object file: NErrorWhilePythonObject
- libmysqlclient.so.16: cannot open shared object file: No such file or directoryIBMMySqlclientObject
- Git (gnome-ssh-askpass:3871): Gtk-WARNING **: cannot open display:Git
- libcap.so.1:cannot open shared object file: No such file or directoryObject
- libiconv.so.2: cannot open shared object file: No such filObject
- libXext.so.6: cannot open shared object file: No such file or directoryObject