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

innobackupex-1.5.1: Error: Original data directory

mudavadkarmudavadkar EntrantCurrent User Role Beginner
Mysql Ver 14.14 Distrib 5.5.20. installed backup percona-xtrabackup-2.1.9-744.rhel6.x86_64

Generated and restored full backup trhough backup-runner.sh. But unable to install incrememntal backup while running backup script it is giving following error.

xtrabackup_55 version 2.1.9 for Percona Server 5.5.35 Linux (x86_64) (revision id: 744)
incremental backup from 35492323540 is enabled.
xtrabackup: cd to /backup/full/2014-11-24_10-22-48
xtrabackup: This target seems to be already prepared.
xtrabackup: error: This incremental backup seems not to be proper for the target.
xtrabackup: Check 'to_lsn' of the target and 'from_lsn' of the incremental.
innobackupex-1.5.1: Error:
innobackupex-1.5.1: ibbackup failed at /usr/bin/innobackupex-1.5.1 line 2560.

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    It seems like your script is not configured correctly for incremental-lsn. Check this link for incremental backup example http://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/incremental_backups_innobackupex.html
  • mudavadkarmudavadkar Entrant Current User Role Beginner
    I have copied script from url make necessary changes in directory path in script. Actually restoring it on different machine. full backup restores fine but not able to restore incremental backup getting following error

    # sh innobackupex-restore.sh /backup/incr/2014-11-24_10-22-48/2014-11-24_10-43-38/
    innobackupex-restore.sh: MySQL backup script
    started: Mon Dec 1 16:30:38 GMT 2014

    Restore 2014-11-24_10-22-48 up to incremental 2014-11-24_10-43-38

    Replay committed transactions on full backup
    Applying 2014-11-24_10-43-38 to full ...
    innobackupex-1.5.1 failed:

    ERROR OUTPUT from innobackupex-1.5.1

    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

    This software is published under
    the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

    Get the latest version of Percona XtraBackup, documentation, and help resources:
    http://www.percona.com/xb/p

    IMPORTANT: Please check that the apply-log run completes successfully.
    At the end of a successful apply-log run innobackupex-1.5.1
    prints "completed OK!".



    141201 16:30:40 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup_55 --defaults-file="/etc/my.cnf" --defaults-group="mysqld" --prepare --target-dir=/backup/full/2014-11-24_10-22-48 --apply-log-only --use-memory=1024M --incremental-dir=/backup/incr/2014-11-24_10-22-48/2014-11-24_10-43-38 --tmpdir=/tmp

    xtrabackup_55 version 2.1.9 for Percona Server 5.5.35 Linux (x86_64) (revision id: 744)
    incremental backup from 35492323540 is enabled.
    xtrabackup: cd to /backup/full/2014-11-24_10-22-48
    xtrabackup: This target seems to be already prepared.
    xtrabackup: error: This incremental backup seems not to be proper for the target.
    xtrabackup: Check 'to_lsn' of the target and 'from_lsn' of the incremental.
    innobackupex-1.5.1: Error:
    innobackupex-1.5.1: ibbackup failed at /usr/bin/innobackupex-1.5.1 line 2560.
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.