MySQL Forums
Forum List  »  Backup

Please help with Enterprise Backup Failure - URGENT
Posted by: Venugopal Saride
Date: January 31, 2012 11:32AM

We had the script working but due to recent change in INNODB Engine it is failing with below error.

We commented the "innodb_data_file_path" in my.cnf to enable "innodb_file_per_table" option. If I turn ON "innodb_data_file_path" mysql is not starting up.

-bash-3.2$ ./innobackup --user=root --password=<password> --compress /data/database/mysql/my.cnf /data/database/backup/
innobackup: INFO: Starting innobackup with following arguments:
./innobackup --user=root --password=<password> --compress /data/database/mysql/my.cnf /data/database/backup/
innobackup: INFO: Unique generated backup id for this is 13280309565612550
innobackup: INFO: IMPORTANT: Please check that backup run completes successfully.
At the end of a successful 'backup' run mysqlbackup
prints "mysqlbackup completed OK!".

innobackup: ERROR: config file '/data/database/mysql/my.cnf' does not contain 'innodb_data_file_path'.

You have to specify it explicitly in config file.

Options: ReplyQuote


Subject
Views
Written By
Posted
Please help with Enterprise Backup Failure - URGENT
2300
January 31, 2012 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.