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