Announcement

Announcement Module
Collapse
No announcement yet.

restoring from innobackupex increment backup

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • restoring from innobackupex increment backup

    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.

    Comment

    Working...
    X