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

restoring from innobackupex increment backup

rei125rei125 EntrantCurrent User Role Beginner

I've tried incremental backup.
I followed the intruction below, but it just doesn't work. ncremental_backups_innobackupex.html

(1) First, making a full backup

innobackupex --user=root /var/testbk/full</pre>

(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</pre>

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</pre>

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</pre>

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.</pre>

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

Thank you.


  • rei125rei125 Entrant Current User Role Beginner
    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</pre>

    --redo-only is only needed for first incremental?

    Thank you.
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.