Not the answer you need?
Register and ask your own question!

[Incremental Backup] I can't restore the first incremental backup

BoadriusBoadrius EntrantInactive User Role Beginner
Good Morning everyone,

I'm working with innobackupex to generate some incremental backups from my database. The problem is:
I can genere the incremental backups from a full base backup but when I prepared I can't restore the first incremental backup. I've used to the manual from "https://www.percona.com/doc/percona-xtrabackup/2.3/index.html"

The commands that I've used:

Creating the database:
$ sudo innobackupex --user=root --password=XXXX /home/beto/xtrabackup/inc2-sense-compact
Now the BASE DIR: 2015-11-18_08-32-18
$ sudo innobackupex --user=root --password=XXXX --incremental /home/beto/xtrabackup/inc2-sense-compact --incremental-basedir=2015-11-18_08-32-18
The first incremental backup: 2015-11-18_08-43-53
$ sudo innobackupex --user=root --password=XXXX --incremental /home/beto/xtrabackup/inc2-sense-compact --incremental-basedir=2015-11-18_08-43-53
The second incremental backup: 2015-11-18_09-25-27

Prepare it:
$ sudo innobackupex --user=root --password=XXXX --apply-log --redo-only 2015-11-18_08-32-18

Up to this point all is ok, but when I execute the first incremental backup... doesn't work!
$ sudo innobackupex --user=root --password=XXXX --apply-log --redo-only 2015-11-18_08-32-18 --incremental-dir=2015-11-18_08-43-53
151118 09:35:57 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.3.2 based on MySQL server 5.6.24 Linux (i686) (revision id: 306a2e0)
incremental backup from 3228084 is enabled.
xtrabackup: cd to /home/beto/xtrabackup/inc2-sense-compact/2015-11-18_08-32-18
xtrabackup: This target seems to be already prepared with --apply-log-only.
2015-11-18 09:35:57 b735e700  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
xtrabackup: Warning: cannot open 2015-11-18_08-43-53/xtrabackup_logfile. will try to find.
2015-11-18 09:35:57 b735e700  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
  xtrabackup: Fatal error: cannot find 2015-11-18_08-43-53/xtrabackup_logfile.
xtrabackup: Error: xtrabackup_init_temp_log() failed.

What's the matter? Any suggestion?

Best rgrds,
Boadrius
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.