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)
• Status: Verified
• Category: MySQL Enterprise Backup
• Severity: S3 (Non-critical)
• Version: 3.9.0, 3.11.1
• OS: Any
• CPU Architecture: Any

[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