# Xtrabackup prepare warning **URL:** \ **Category:** Percona XtraBackup\ **Created:** [May 12, 2013, 9:00pm UTC](https://forums.percona.com/t/xtrabackup-prepare-warning/2672 "2013-05-12T21:00:29Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![jmhong](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@jmhong](https://forums.percona.com/u/jmhong)\ **Post date:** [May 12, 2013, 9:00pm UTC](https://forums.percona.com/t/xtrabackup-prepare-warning/2672/1 "2013-05-12T21:00:29Z")
Hi, I tried to compressed backup & recovery test. The backup compression was successfully finished. But, When I execute “prepare” the backup-set, it was failed. (It could not found binary log file and position. ) - MySQL version is 5.6.10 - xtrabackup-2.0.6 I hope someone who know about this warning, help me. 1. When I tried backup, I executed this command. ./percona-xtrabackup-2.0.6/bin/xtrabackup\_56 --defaults-file=/etc/my.cnf --target-dir=/backup1/Compress\_Back --backup --compress ./xtrabackup\_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86\_64) (revision id: undefined) xtrabackup: uses posix\_fadvise(). xtrabackup: cd to /data1/mysql xtrabackup: Target instance is assumed as followings. xtrabackup: innodb\_data\_home\_dir = xtrabackup: innodb\_data\_file\_path = /data1/ibdata1:5G; xtrabackup: innodb\_log\_group\_home\_dir = /data1/mysqllog xtrabackup: innodb\_log\_files\_in\_group = 3 xtrabackup: innodb\_log\_file\_size = 225443840 2013-05-13 10:49:19 2ab938f72f90 InnoDB: Using Linux native AIO > > log scanned up to (79082747) > > [01] Compressing /data1/ibdata1 to /backup1/Compress\_Back/ibdata1.qp > > log scanned up to (79082747) > > log scanned up to (79082747) > > log scanned up to (79082747) > > log scanned up to (79082747) > > log scanned up to (79082747) > > log scanned up to (79082747) > > [01] …done > > [01] Compressing ./hong/ttt.ibd to /backup1/Compress\_Back/./hong/ttt.ibd.qp > > log scanned up to (79082747) > > [01] …done > > [01] Compressing ./hong/xxx.ibd to /backup1/Compress\_Back/./hong/xxx.ibd.qp > > [01] …done > > [01] Compressing ./mysql/slave\_worker\_info.ibd to /backup1/Compress\_Back/./mysql/slave\_worker\_info.ibd.qp > > [01] …done > > [01] Compressing ./mysql/slave\_master\_info.ibd to /backup1/Compress\_Back/./mysql/slave\_master\_info.ibd.qp > > [01] …done > > [01] Compressing ./mysql/slave\_relay\_log\_info.ibd to /backup1/Compress\_Back/./mysql/slave\_relay\_log\_info.ibd.qp > > [01] …done > > [01] Compressing ./mysql/innodb\_index\_stats.ibd to /backup1/Compress\_Back/./mysql/innodb\_index\_stats.ibd.qp > > [01] …done > > [01] Compressing ./mysql/innodb\_table\_stats.ibd to /backup1/Compress\_Back/./mysql/innodb\_table\_stats.ibd.qp > > [01] …done > > xtrabackup: The latest check point (for incremental): ‘79082747’ > > xtrabackup: Stopping log copying thread. > > .\>\> log scanned up to (79082747) 1. execute prepare command, it was failed. ./percona-xtrabackup-2.0.6/bin/xtrabackup\_56 --defaults-file=/etc/my.cnf --target-dir=/backup1/Compress\_Back --prepare ./xtrabackup\_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86\_64) (revision id: undefined) xtrabackup: cd to /backup1/Compress\_Back 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 = /data1/ibdata1:5G; xtrabackup: innodb\_log\_group\_home\_dir = ./ xtrabackup: innodb\_log\_files\_in\_group = 3 xtrabackup: innodb\_log\_file\_size = 225443840 2013-05-13 10:53:51 2ab24e32ef90 InnoDB: Using Linux native AIO xtrabackup: Temporary instance for recovery is set as followings. xtrabackup: innodb\_data\_home\_dir = ./ xtrabackup: innodb\_data\_file\_path = /data1/ibdata1:5G; xtrabackup: innodb\_log\_group\_home\_dir = ./ xtrabackup: innodb\_log\_files\_in\_group = 3 xtrabackup: innodb\_log\_file\_size = 225443840 2013-05-13 10:53:51 2ab24e32ef90 InnoDB: Using Linux native AIO xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: Progress in MB: 100 200 InnoDB: Progress in MB: 100 200 InnoDB: Progress in MB: 100 200 [notice (again)] [COLOR=#FF0000]If you use binary log and don’t use any hack of group commit, [COLOR=#FF0000]the binary log position seems to be: [COLOR=#FF0000]xtrabackup: ################################################## ###### [COLOR=#FF0000]xtrabackup: # !!WARNING!! # [COLOR=#FF0000]xtrabackup: # The transaction log file is corrupted. # [COLOR=#FF0000]xtrabackup: # The log was not applied to the intended LSN! # [COLOR=#FF0000]xtrabackup: ################################################## ###### [COLOR=#FF0000]xtrabackup: The intended lsn is 79082747 [COLOR=#FF0000]xtrabackup: starting shutdown with innodb\_fast\_shutdown = 1 ---
**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\ **Post date:** [May 13, 2013, 5:40am UTC](https://forums.percona.com/t/xtrabackup-prepare-warning/2672/2 "2013-05-13T05:40:56Z")
See [url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/howtos/recipes_ibkx_compressed.html%5B/url%5D) ---
**Author:** ![jmhong](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@jmhong](https://forums.percona.com/u/jmhong)\ **Post date:** [May 13, 2013, 7:18pm UTC](https://forums.percona.com/t/xtrabackup-prepare-warning/2672/3 "2013-05-13T19:18:00Z")
Can I use only innobackupex when compress the backup-set ? I’d like to use xtrabackup binary… ( innodb tables backup only )