Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex restore incremental backup failed ?

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

  • innobackupex restore incremental backup failed ?

    Hello ,Everyone
    ask a restore question ?

    I used mysql 5.6.14 community, percona xtrabackup 2.1.8 x64 used for backup.

    backup process:
    1. Full backup (normal) , backup full path :
    /home/backup/2014-04-01_17-00-15/
    innobackupex --defaults-file=/home/mysql/my.cnf --user=root --password=xxxxxx --socket=/home/mysqldata/data/mysql.sock /home/backup

    2. first incremental backup (normal) , backup path: /home/backup/2014-04-01_17-03-35
    innobackupex --defaults-file=/home/mysql/my.cnf --user=root --password=xxxxxx --socket=/home/mysqldata/data/mysql.sock --incremental /home/backup --incremental-basedir /home/backup/2014-04-01_17-00-15/

    3. second incremental backup (normal), backup path: /home/backup/2014-04-01_17-12-01/
    innobackupex --defaults-file=/home/mysql/my.cnf --user=root --password=xxxxxx --socket=/home/mysqldata/data/mysql.sock --incremental /home/backup --incremental-basedir /home/backup/2014-04-01_17-03-35


    restore process:
    -- 1. restore full backup ( normal)

    innobackupex --defaults-file=/home/mysql/my.cnf --user=root --password=xxxxxx --socket=/home/mysqldata/data/mysql.sock --apply-log /home/backup/2014-04-01_17-00-15/

    -- 2. restore first incremental (normal)
    innobackupex --defaults-file=/home/mysql/my.cnf --user=root --password=xxxxxx --socket=/home/mysqldata/data/mysql.sock --apply-log --redo-only /home/backup/2014-04-01_17-00-15/ --incremental-dir /home/backup/2014-04-01_17-03-35/

    -- 3. restore second incremental ( failed)
    innobackupex --defaults-file=/home/mysql/my.cnf --user=root --password=xxxxxx --socket=/home/mysqldata/data/mysql.sock --apply-log /home/backup/2014-04-01_17-00-15/ --incremental-dir /home/backup/2014-04-01_17-12-01/

    Error : unable open undo tablespace ./undo001

    ------------------------------------------------------------------------------------------------------------------------
    remak:

    after set separately undo tablespace, execute last
    incremental restore , display error above.

    if not set separately undo tablespace , restore normal.
Working...
X