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)
• Status: Closed
• 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
• 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.