# error while prepare the incremental backups

**URL:** <https://forums.percona.com/t/error-while-prepare-the-incremental-backups/2292>\
**Category:** Percona XtraBackup\
**Created:** [September 13, 2012, 3:13pm UTC](https://forums.percona.com/t/error-while-prepare-the-incremental-backups/2292 "2012-09-13T15:13:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![karpagaraj](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@karpagaraj](https://forums.percona.com/u/karpagaraj)\
**Post date:** [September 13, 2012, 3:13pm UTC](https://forums.percona.com/t/error-while-prepare-the-incremental-backups/2292/1 "2012-09-13T15:13:16Z")

</div>

# I tried full backup prepare

[root@mytestmachine]# xtrabackup\_51 --prepare --apply-log-only --target-dir=/root/backup/allbackup/1/2012-09-09\_00-12-52  
xtrabackup\_51 version 2.0.2 for MySQL server 5.1.59 unknown-linux-gnu (x86\_64) (revision id: 461)  
xtrabackup: cd to /root/backup/allbackup/1/2012-09-09\_00-12-52  
xtrabackup: This target seems to be already prepared.  
xtrabackup: notice: xtrabackup\_logfile was already used to ‘–prepare’.  
xtrabackup: Temporary instance for recovery is set as followings.  
xtrabackup: innodb\_data\_home\_dir = ./  
xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextend  
xtrabackup: innodb\_log\_group\_home\_dir = ./  
xtrabackup: innodb\_log\_files\_in\_group = 2  
xtrabackup: innodb\_log\_file\_size = 5242880  
xtrabackup: Temporary instance for recovery is set as followings.  
xtrabackup: innodb\_data\_home\_dir = ./  
xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextend  
xtrabackup: innodb\_log\_group\_home\_dir = ./  
xtrabackup: innodb\_log\_files\_in\_group = 2  
xtrabackup: innodb\_log\_file\_size = 5242880  
xtrabackup: Starting InnoDB instance for recovery.  
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)  
InnoDB: The InnoDB memory heap is disabled  
120913 13:34:32 InnoDB: Initializing buffer pool, size = 100.0M  
120913 13:34:32 InnoDB: Completed initialization of buffer pool

[notice (again)]  
If you use binary log and don’t use any hack of group commit,  
the binary log position seems to be:  
InnoDB: Last MySQL binlog file position 0 867857238, file name ./mysql-bin.002108

# xtrabackup: starting shutdown with innodb\_fast\_shutdown = 1 120913 13:34:32 InnoDB: Starting shutdown… 120913 13:34:32 InnoDB: Shutdown completed; log sequence number 412 872729100

I facing the error while prepare the incremental backups  
This is the error I facing here  
[root@mytestmachine]# xtrabackup\_51 --prepare --apply-log-only --incremental-lsn=‘412 872729100’ --target-dir=/root/backup/allbackup/1/2012-09-09\_00-12-52/ --incremental-dir=/root/backup/allbackup/2/2012-09-10\_00-06- 25/  
xtrabackup: error: failed to read metadata from /root/backup/allbackup/2/2012-09-10\_00-06-25//xtrabackup\_che ckpoints

# mysql and os details

# Mysql version details

# mysqld\_multi --version

mysqld\_multi version 2.16 by Jani Tolonen

# mysql --version

mysql Ver 14.14 Distrib 5.5.23, for linux2.6 (x86\_64) using readline 5.1

# linux OS details

Linux version 2.6.35.13-32 (root@linux) (gcc version 4.2.4)/x86\_64

Kindly help me to figure out the problem

Thanks  
raj

---

<div class="post-metadata">

**Author:** ![martin.arrieta](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/martin.arrieta/32/16888_2.png) [@martin.arrieta](https://forums.percona.com/u/martin.arrieta)\
**Post date:** [September 13, 2012, 3:41pm UTC](https://forums.percona.com/t/error-while-prepare-the-incremental-backups/2292/2 "2012-09-13T15:41:43Z")

</div>

Raj ,

You are using xtrabackup\_51 for mysql 5.5.23, please take a look to this link that explains which binary you have to use for each mysql version.

[http://www.percona.com/doc/percona-xtrabackup/xtrabackup\_bin](http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin) /choosing\_binary.html

Martin.

---

<div class="post-metadata">

**Author:** ![karpagaraj](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@karpagaraj](https://forums.percona.com/u/karpagaraj)\
**Post date:** [September 13, 2012, 3:46pm UTC](https://forums.percona.com/t/error-while-prepare-the-incremental-backups/2292/3 "2012-09-13T15:46:36Z")

</div>

Hi Martin,

Thank you very much. I will work according to this and let u know about the result.

Thanks  
raj