MySQL Forums
Forum List  »  Backup

mysqlbackup preparing the backup for restore fails
Posted by: dvsrk 563
Date: September 08, 2016 03:15PM


I'm folloing the instructions from the "MySQL Enterprise Backup 3.12 User's Guide - Chapter 6 Using MySQL Enterprise Backup with Replication"

I'm able to take the successful backup from master & copied it over to the slave. On slave when i'm trying to prepare the backup for restore using apply-log option I'm getting an error as listed below,

[root@mysqlslave x]# mysqlbackup --backup-dir=/usr/x/mysql_backup/ apply-log
MySQL Enterprise Backup version 4.0.3 Linux-3.8.13-118.4.2.el7uek.x86_64-x86_64 [2016/08/04]
Copyright (c) 2003, 2016, Oracle and/or its affiliates. All Rights Reserved.

mysqlbackup: INFO: Starting with following command line ...
mysqlbackup --backup-dir=/usr/xmysql_backup/ apply-log

mysqlbackup: INFO:
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'apply-log' run mysqlbackup
prints "mysqlbackup completed OK!".

mysqlbackup: [Warning] World-writable config file '/usr/x/mysql_backup/backup-my.cnf' is ignored.
160908 13:52:02 mysqlbackup: INFO: MEB logfile created at /usr/x/mysql_backup/meta/MEB_2016-09-08.13-52-02_apply_log.log

mysqlbackup: ERROR: Mandatory parameter innodb_data_file_path is missing in
backup-my.cnf config file: /usr/x/mysql_backup/backup-my.cnf
mysqlbackup: ERROR: Could not load contents of directory '/usr/x/mysql_backup/'.

mysqlbackup failed with errors!

Could someone guide me if i'm missing anything here...

Thank you.

Options: ReplyQuote

Written By
mysqlbackup preparing the backup for restore fails
September 08, 2016 03:15PM

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.