Bug #83144 mysqlpump reads mysql_dump group, not mysqlpump in config-group
Submitted: 26 Sep 2016 6:48 Modified: 25 Feb 2020 19:09
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqlpump Command-line Client Severity:S3 (Non-critical)
Version:5.7.15, 5.7.21, 8.0.0, 8.0.4, 8.0.18 OS:Any
Assigned to: CPU Architecture:Any

[26 Sep 2016 6:48] Tsubasa Tanaka
Description:
Docs for 5.7 and 8.0 describe "mysqlpump supports the following options, which can be specified on the command line or in the [mysqlpump] and [client] groups of an option file."

http://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
http://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

But the truth, mysqlpump reads [mysql_dump] and [client] group, not [mysqlpump].

This maybe related Bug#80834 .

How to repeat:
See source code.

https://github.com/mysql/mysql-server/blob/mysql-5.7.15/client/dump/program.cc#L266-L271
https://github.com/mysql/mysql-server/blob/mysql-8.0.0/client/dump/program.cc#L266-L271

Suggested fix:
Fix the docs.
[26 Sep 2016 6:49] Tsubasa Tanaka
Fix synopsis.
[26 Sep 2016 6:49] Tsubasa Tanaka
Change category to "Documentation"
[26 Sep 2016 7:57] MySQL Verification Team
Hello Tanaka-San,

Thank you for the report.

Thanks,
Umesh
[18 Oct 2016 13:04] Paul DuBois
Posted by developer:
 
This is not a docs bug, it's a mysqlpump bug. Client programs should read, in addition to the [client] group, the group with the same name as the client program, not some other group.

mysqlpump should read [client] and [mysqlpump], not [client] and [mysql_dump].
[4 Apr 2018 6:54] Tsubasa Tanaka
This issue is still in 5.7.21 and 8.0.4.
[4 Apr 2018 6:57] Tsubasa Tanaka
Patch for mysqlpump in MySQL 8.0.4

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug83144_for_mysql804.patch (application/octet-stream, text), 533 bytes.

[24 Jun 2018 7:55] MySQL Verification Team
Bug #91254 marked as duplicate of this one
[5 Jan 2020 5:32] Tsubasa Tanaka
MySQL 8.0.18 has not been fixed yet.

But document still describes

> mysqlpump supports the following options, which can be specified on the command line or in the [mysqlpump] and [client] groups of an option file.

https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#mysqlpump-option-summary

This is *completely* wrong information.

Should fix load_default_groups or the document.
[25 Feb 2020 19:09] Paul DuBois
Posted by developer:
 
Fixed in 5.7.30, 8.0.20.

Previously, mysqlpump read the [mysql_dump] and [client] groups from
option files. mysqlpump now additionally reads the [mysqlpump]. The
[mysql_dump] group is still accepted but is deprecated.