Announcement

Announcement Module
Collapse
No announcement yet.

Incremental backup with Xtrabackup

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

  • Incremental backup with Xtrabackup

    Hi,

    I'm trying to use innobackupex and xtrabackup to make incremental backups but so far no luck.

    First I created a full backup


    innobackupex --password=xxxxx --no-lock --tmpdir=/tmp /data/backups/full/......innobackupex: Backup created in directory '/data/backups/full/2011-05-02_02-13-49'110502 02:21:03 innobackupex: completed OK!


    Everything went smoothly and I end up with a time stamped folder containing


    I tried then to create a incremental backup based on this full back up


    innobackupex --incremental --password=xxxxx --tmpdir=/tmp --no-lock --incremental-basedir=/data/backups/full/2011-05-02_02-13-49/ incremental/......xtrabackup: The latest check point (for incremental): '245:3281249024'>> log scanned up to (245 3288192768)xtrabackup: Stopping log copying thread.xtrabackup: Transaction log of lsn (245 3257702458) to (245 3288192768) was copied.innobackupex: Backup created in directory '/data/backups/incremental/2011-05-02_02-27-29'


    So far everything looks ok
    delta files have been successfully created


    When I try to apply those delta files to the full backup directory I get the following


    xtrabackup --prepare --apply-log-only --target-dir=/data/backups/full/2011-05-02_02-13-49/ --incremental-dir=/data/backups/incremental/2011-05-02_02-27-29/xtrabackup: error: failed to read metadata from /data/backups/incremental/2011-05-02_02-27-29//xtrabackup_checkpoints


    Any help would be really appreciated.

    Thx in advance

  • #2
    Please try this.It may sort out the problem.Hope this helps.
    # xtrabackup --backup --target-dir=/full_backups

    To make changes to the database to take an incremental backup.

    To take a incremental backup I ran the following:

    # xtrabackup --backup --target-dir=/incremental --incremental-
    basedir=/full_backups

    Preparing the full backup:

    # xtrabackup --prepare --target-dir=/full_backups

    Applied incremental backup to the full backup.

    # xtrabackup --prepare --target-dir=/full_backups --incremental-dir=/
    incremental
    # innobackupex-1.5.1 --copy-back /full_backups/

    Comment


    • #3
      Thx a lot for your answer. I finally figured it out and will post a full how to very soon.

      Comment

      Working...
      X