# Restore with innobackupex --apply-log fails

**URL:** <https://forums.percona.com/t/restore-with-innobackupex-apply-log-fails/2232>\
**Category:** Percona XtraBackup\
**Created:** [April 11, 2012, 5:29am UTC](https://forums.percona.com/t/restore-with-innobackupex-apply-log-fails/2232 "2012-04-11T05:29:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmartensson](https://avatars.discourse-cdn.com/v4/letter/t/3ec8ea/32.png) [@tmartensson](https://forums.percona.com/u/tmartensson)\
**Post date:** [April 11, 2012, 5:29am UTC](https://forums.percona.com/t/restore-with-innobackupex-apply-log-fails/2232/1 "2012-04-11T05:29:02Z")

</div>

Hi,  
we are reinstalling our DB servers with CentOS 6.2 and I am having problems to restore a backup made with xtrabackup on CentOS 6.2.

The backup is made using innobackupexec and is streamed to our backupserver (that part is left out from the example below):

innobackupex-1.5.1 --safe-slave-backup --defaults-file=/etc/my.cnf --user=backupuser --password=passwd --slave-info --stream=tar /tmp

After this, I scp:d the backupfile to a new server with the same install base and exctracted it, now I want to run --apply-log but that throws out the error:

[root@server ~]# innobackupex --use-memory=2G --apply-log .InnoDB Backup Utili[…][…]sh: line 1: --print-param: command not foundinnobackupex: fatal error: no ‘mysqld’ group in MySQL optionsinnobackupex: fatal error: OR no ‘datadir’ option in group ‘mysqld’ in MySQL options

If I try:

[root@server ~]# innobackupex --defaults-file=/etc/my.cnf --use-memory=2G --apply-log .

I get the following error:

sh: line 1: --defaults-file=/etc/my.cnf: No such file or directoryinnobackupex: fatal error: no ‘mysqld’ group in MySQL optionsinnobackupex: fatal error: OR no ‘datadir’ option in group ‘mysqld’ in MySQL options

Details:  
CentOS 6.2  
xtrabackup-1.6.5-328.rhel6.x86\_64  
Percona-Server-client-51-5.1.60-rel13.1.413.rhel.x86\_64  
Percona-Server-server-51-5.1.60-rel13.1.413.rhel.x86\_64  
Percona-Server-shared-compat-5.5.21-rel25.1.234.rhel6.x86\_64

---

<div class="post-metadata">

**Author:** ![tmartensson](https://avatars.discourse-cdn.com/v4/letter/t/3ec8ea/32.png) [@tmartensson](https://forums.percona.com/u/tmartensson)\
**Post date:** [April 11, 2012, 7:21am UTC](https://forums.percona.com/t/restore-with-innobackupex-apply-log-fails/2232/2 "2012-04-11T07:21:52Z")

</div>

Running the xtrabackup command manually  
xtrabackup --defaults-file=/etc/my.cnf --use-memory=2G --prepare --target-dir=/data/backup/  
works, so I guess the perlscript (innobackupex) is broken.