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 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

[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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.