# XtraBackup Error when using apply-log

**URL:** <https://forums.percona.com/t/xtrabackup-error-when-using-apply-log/3873>\
**Category:** Percona XtraBackup\
**Created:** [November 11, 2014, 9:16pm UTC](https://forums.percona.com/t/xtrabackup-error-when-using-apply-log/3873 "2014-11-11T21:16:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![epinc](https://avatars.discourse-cdn.com/v4/letter/e/bbe5ce/32.png) [@epinc](https://forums.percona.com/u/epinc)\
**Post date:** [November 11, 2014, 9:16pm UTC](https://forums.percona.com/t/xtrabackup-error-when-using-apply-log/3873/1 "2014-11-11T21:16:52Z")

</div>

I was trying out XtraBackup but am getting this error when I try to apply-log…

“no innodb\_data\_file\_path option in group mysqld in server configuration file”

I do not have that statement in my cnf file because I am using innodb-file-per-table

What am I doing wrong here? Thanks.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [November 15, 2014, 8:21am UTC](https://forums.percona.com/t/xtrabackup-error-when-using-apply-log/3873/2 "2014-11-15T08:21:57Z")

</div>

Can you please share your my.cnf and exact command you used to take backup along with backup log to identify what causing the issue.  
Also show me the output of

$ xtrbackup --version

---

<div class="post-metadata">

**Author:** ![sibidas](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@sibidas](https://forums.percona.com/u/sibidas)\
**Post date:** [January 20, 2015, 3:04am UTC](https://forums.percona.com/t/xtrabackup-error-when-using-apply-log/3873/3 "2015-01-20T03:04:34Z")

</div>

I had the same issue. I was able to successfully start the apply-log process after adding the following inside the file backup-my.cnf which is precent in the backup dir.  
innodb\_data\_file\_path=ibdata1:10M:autoextend

I got the value of innodb\_data\_file\_path from the server from which I took the backup. Issue the command "show variables like ‘innodb\_data\_file\_path’ " in mysql prompt of master and put that value here. Hope this helps.

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [January 22, 2015, 2:59am UTC](https://forums.percona.com/t/xtrabackup-error-when-using-apply-log/3873/4 "2015-01-22T02:59:21Z")

</div>

Hi,

Agree with sibidas, you should add innodb\_data\_file\_path settings to my.cnf because xtrabackup will get all innodb related details while taking backup and stored in backup-my.cnf (in backup dir) . Even if you are using innodb\_file\_per\_table, you’ll have system tablespace i.e ibdata1. You can add path in backup-my.cnf and try to prepare again.