Bug #71601 Option file list is not cosistend between mysqld and mysqlbackup
Submitted: 6 Feb 2014 8:16 Modified: 19 Jan 2015 20:46
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S3 (Non-critical)
Version:3.9.0, 3.11.1 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D4 (Minor)

[6 Feb 2014 8:16] Daniël van Eeden
Description:
The list with option files which are read by mysqlbackup and mysqld have a small difference.

mysqld 5.6.15 (enterprise)
mysqlbackup 3.9.0

How to repeat:
# mysqld --help --verbose 2> /dev/null | grep -B 1 '/etc/my.cnf'
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

# mysqlbackup --help 2> /dev/null | grep -B 1 '/etc/my.cnf'
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

Suggested fix:
Make sure both option file lists are equal.
[6 Feb 2014 17:23] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior:

$ ~/Downloads/mysql-5.6.15-linux-glibc2.5-x86_64/bin/mysqld --help --verbose 2> /dev/null | grep -B 1 '/etc/my.cnf'
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 

Which exact version of MySQL server do you use?
[6 Feb 2014 21:13] Daniël van Eeden
I use 5.6.15 enterprise RPM on RHEL6
[19 Jan 2015 20:46] Sveta Smirnova
Thank you for the feedback.

Verified as described: MEB from RPM package reads option files in different order than RPM version of server.

Workaround: specify --defaults-file or --defaults-extra-file option