Good day,
I’m fairly new with Percona Xtrabackup, and I’m having a difficulty restoring a backup. First of, I’ve created a script to run a partial backup every x hours. Here’s the backup command I’m using in my script:
innobackupex --include=$database $backupdir --host=$host --user=$username --password=$password --stream=tar | gzip -> $backupdir"database-(date +%Y-%m-%d).tar.gz"
I could say my backup is working since I do see the backup file being created and when I extract the backup, it contains *ibd file. Now, the problem is that when I try to prepare the backup, I get this:
innobackupex --apply-log --export /backups/xtrabackup-data/backup/12122020/
xtrabackup: recognized server arguments:
xtrabackup: recognized client arguments:
210107 02:05:00 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints “completed OK!”.
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
xtrabackup: auto-enabling --innodb-file-per-table due to the --export option
xtrabackup: cd to /backups/xtrabackup-data/backup/12122020/
xtrabackup: Error: cannot open ./xtrabackup_checkpoints
xtrabackup: Error: failed to read metadata from ‘./xtrabackup_checkpoints’
I look into the files extracted, but I don’t see a file called xtrabackup_checkpoints. All I have are *.ibd files and an ibdata1.
Here’s my percona xtrabackup version:
innobackupex --version
xtrabackup: recognized server arguments: --datadir=/data/mysql --innodb_flush_log_at_trx_commit=0 --innodb_flush_method=O_DIRECT --innodb_log_buffer_size=32M --innodb_read_io_threads=32 --innodb_write_io_threads=16 --innodb_log_file_size=1G --innodb_buffer_pool_size=10G --open_files_limit=50000
innobackupex version 2.4.20 Linux (x86_64) (revision id: c8b4056)
Any help is highly appreciated. Also, Is it possible to restore a partial backup without preparing? Thank you