restoring from innobackupex increment backup

MySQL & MariaDB Percona XtraBackup
1

Hi,

I’ve tried incremental backup.
I followed the intruction below, but it just doesn’t work.
http://www.percona.com/doc/percona-xtrabackup/innobackupex/i ncremental_backups_innobackupex.html

backup

(1) First, making a full backup

innobackupex --user=root /var/testbk/full

(2) Making incremental backup after one hour

innobackupex --user=root --incremental /var/testbk/inc --incremental-basedir=/var/testbk/full/2012-06-08_17-38-46

prepare

Now i would like to prepare it.

First, --apply-log --redo-only on the full backup (base)

innobackupex --user=root --apply-log --redo-only /var/testbk/full/2012-06-08_17-38-46

The problem is next, when i tried to apply-log on the increment backup.

innobackupex --user=root --apply-log --redo-only /var/testbk/full/2012-06-08_17-38-46 --incremental-dir=/var/testbk/inc/2012-06-08_17-53-07

IT fails and give me the following errors.

xtrabackup: cd to /var/testbk/full/2012-06-08_17-38-46xtrabackup: This target seems to be not prepared yet.xtrabackup: error: applying incremental backup needs target prepared.

Do i need to omit the --read-only before apply-log for the increment directory?

Thank you.

2

sorry… i forgot to --apply-log for the full backup.
What a careless mistake.

Thank you anyway.

Another question.
As in manual,

innobackupex --apply-log --redo-only BASE-DIR --incremental-dir=INCREMENTAL-DIR-1innobackupex --apply-log BASE-DIR --incremental-dir=INCREMENTAL-DIR-2

–redo-only is only needed for first incremental?

Thank you.