So I have a backup I’m trying to restore into a new environment, but every time I attempt to prepare the backup for restoration, the defaults file in the backup location is ignored, and there is an error that the innodb_data_file_path parameter is not there. I figured this was related to permissions, as it is world-writable on a cifs share, and so copied it off to my pwd. However, the error is the same, except that it is now showing the same error but with the new defaults file name in it instead. The file I set as the new defaults file apparently doesn’t have the innodb_data_file_path entry in it (I am 100% certain that it does, I am looking at it right now!!).
The file permissions on the new file are 644. I have no idea why this is happening. I suspect this may be related to the fact the backup is on a CIFS share, but need to be sure this is the case, however we don’t have any spare disks to use to put the backup on to before restoring. See output from innobackupex command below:
innobackupex --defaults-file ./backup-my.cnf --apply-log --export /backups/20150723
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
150727 11:59:19 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints “completed OK!”.
Warning: World-writable config file ‘/mnt/backup/mysql/20150723/backup-my.cnf’ is ignored
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 4545
main::get_option(‘innodb_data_file_path’) called at /usr/bin/innobackupex line 2631
main::apply_log() called at /usr/bin/innobackupex line 1578
innobackupex: Error: no ‘innodb_data_file_path’ option in group ‘mysqld’ in server configuration file ‘/root/backup-my.cnf’ at /usr/bin/innobackupex line 4545.