# Fails to fully backup or prepare

**URL:** <https://forums.percona.com/t/fails-to-fully-backup-or-prepare/2260>\
**Category:** Percona XtraBackup\
**Created:** [June 15, 2012, 3:22pm UTC](https://forums.percona.com/t/fails-to-fully-backup-or-prepare/2260 "2012-06-15T15:22:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iconx](https://avatars.discourse-cdn.com/v4/letter/i/cab0a1/32.png) [@iconx](https://forums.percona.com/u/iconx)\
**Post date:** [June 15, 2012, 3:22pm UTC](https://forums.percona.com/t/fails-to-fully-backup-or-prepare/2260/1 "2012-06-15T15:22:00Z")

</div>

Hi,

I have a strange thing happening with some of our servers that I use xtrabackup on. First I run the command ‘innobackupex --user=root --password=xxxxx /backups’ and it does some backing up and file copying but the resulting files are only half the size of the database. Even if I ‘rm -rf /backups/\*’ and run another backup its the same result.

The second thing is I can never get the apply-log to work it gives an error that says ‘This target seems to be not prepared yet’ and ‘InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.’ and ‘Fatal error: cannot find ./xtrabackup\_logfile.’

Anyone know whats going on here?

John

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [June 18, 2012, 12:41pm UTC](https://forums.percona.com/t/fails-to-fully-backup-or-prepare/2260/2 "2012-06-18T12:41:48Z")

</div>

Do you have multiple MySQL instances on the same server? The first issue sounds like it may be backing up another data folder that you are not intending.

What is the command you are using for the apply-log step?

---

<div class="post-metadata">

**Author:** ![iconx](https://avatars.discourse-cdn.com/v4/letter/i/cab0a1/32.png) [@iconx](https://forums.percona.com/u/iconx)\
**Post date:** [June 19, 2012, 4:14pm UTC](https://forums.percona.com/t/fails-to-fully-backup-or-prepare/2260/3 "2012-06-19T16:14:59Z")

</div>

No, none of these servers are running multiple mysql instances and the mysql versions are mysql-server-5.0.45-7.el5 on CentOS 5.2.

We’re using innobackupex to backup about 4 systems. Three of the systems are running xtrabackup-1.6.5-328.rhel5 and I tested xtrabackup-2.0.0-417.rhel5 on one.

On 2 of the servers the the size of the backup folders matches the size of the database folders in mysql and the apply-log seems to have no problem.

On 1 the sizes match but apply-log fails and on the last a 16GB database comes out in backup as 89M, a 6.5GB database on the same server is 4.8G

All of the servers are configured the same and mysql lives in /var/lib/mysql

Its almost as if some of these servers are stuck on doing only incremental backups, is there a setting somewhere to reset this?

The error message on the failed servers during the apply-log phase says " xtrabackup: Fatal error: cannot find ./xtrabackup\_logfile." On the servers that suceeded there are 5 files:

xtrabackup\_binary  
xtrabackup\_binlog\_info  
xtrabackup\_binlog\_pos\_innodb  
xtrabackup\_checkpoints  
xtrabackup\_logfile

on the failed ones there are only 3:

xtrabackup\_binary  
xtrabackup\_binlog\_info  
xtrabackup\_checkpoints

The apply-log command I’m using is ‘innobackupex --apply-log /backups/2012-06-16\_02-42-44/’