-
Title
MYSQL Enterprise Backup restore fails with "Warning: World-writable config file 'backup-my.cnf' is ignored" -
Description
During MYSQL Enterprise Backup restore and extraction, the restore and extraction failed with the following errors.
MAIN: [Warning] World-writable config file '/usr/netvault/tmp/mysql/MYSQL_MEB_Backup_-_FULL_ENTERPRISE_(Saveset_5)_09.56_04_Jan_2018/backup-my.cnf' is ignored.
180105 09:09:06 MAIN ERROR: Mandatory parameter innodb_data_file_path is missing in backup-my.cnf config file: /usr/netvault/tmp/mysql/MYSQL_MEB_Backup_-_FULL_ENTERPRISE_(Saveset_5)_09.56_04_Jan_2018/backup-my.cnf
180105 09:09:06 MAIN ERROR: Could not load contents of directory '/usr/netvault/tmp/mysql/MYSQL_MEB_Backup_-_FULL_ENTERPRISE_(Saveset_5)_09.56_04_Jan_2018'.
-
Cause
umask is not being set correctly within the MYSQL plugin, causing world-writable files to be generated so the mysqlbackup executable will fail in certain operations. -
Resolution
For the "Mysqlbackup Path" in plugin configuration, please set this to a custom script instead of the mysqlbackup executable.
A sample script preinstalled is located in /usr/netvault/plugins/mysql/mysqlbackup-4.0.sh or /usr/netvault/plugins/mysql/mysqlbackup-3.12.sh.
The scripts can be edited to ensure the custom mysqlbackup path is consistent with your installation.
---------
For Ubuntu on mysql plugin 11.4, please note that the script as it is would not work due to some script compatibility issues on different OS.
Please insert
umask 0133
above the exec /opt/mysql/meb-4.0/bin/mysqlbackup "$@" for it to work.