| Bug #83334 | weird error w. mysqldump | ||
|---|---|---|---|
| Submitted: | 11 Oct 2016 12:56 | Modified: | 4 Nov 2016 20:56 |
| Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 5.7.15 | OS: | Windows (10 Pro 64 bit) |
| Assigned to: | CPU Architecture: | Any | |
[11 Oct 2016 12:56]
Peter Laursen
[11 Oct 2016 12:57]
Peter Laursen
corrected synopsis.
[11 Oct 2016 13:33]
Peter Laursen
hmmm .... ;;-) I wondered if it could be a packaging issue resulting in an old client being bundled. But ... C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump --version mysqldump: [ERROR] unknown option '--no-beep'
[11 Oct 2016 13:45]
Peter Laursen
5.6 and 8.0 not affected C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqldump --version mysqldump Ver 10.13 Distrib 5.6.33, for Win64 (x86_64) C:\Program Files\MySQL\MySQL Server 5.6\bin>cd C:\Program Files\MySQL\MySQL Server 8.0\bin C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump --version mysqldump Ver 10.13 Distrib 8.0.0-dmr, for Win64 (x86_64) C:\Program Files\MySQL\MySQL Server 8.0\bin>
[11 Oct 2016 13:52]
Peter Laursen
Also see http://bugs.mysql.com/bug.php?id=83326. It really looks that a lot of damage was done to mysqldump in the 5.7 distribution tree :(
[11 Oct 2016 13:52]
MySQL Verification Team
I believe the problem is you have a my.ini somewhere, containing no-beep in the [client] section. So move that option to the [mysql] section... or run mysqldump --no-defaults ...
[11 Oct 2016 13:54]
Peter Laursen
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump --version --no-defaults mysqldump: [ERROR] unknown option '--no-beep'
[11 Oct 2016 13:58]
Peter Laursen
I do not think I have any my.ini in 'generic places' like C:\Windows\system etc. Besides then also 5.6 and 8.0 should be affected, right?
[11 Oct 2016 14:06]
Peter Laursen
Ok there as one in C:\Program Files\MySQL\MySQL Server 5.7 reading [client] no-beep (the registry key starting the server uses my.ini from \ProgramData). It explains but it is still does eplains how it came there. I am 99% sure that the Installer copied it there (but it could be an old version that did). But definitely a 5.7 version of the installer.
[11 Oct 2016 14:07]
Peter Laursen
attatching the file if it is interesting
Attachment: my.ini (application/octet-stream, text), 13.48 KiB.
[11 Oct 2016 14:11]
Peter Laursen
is this a bug then C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump --version --no-defaults mysqldump: [ERROR] unknown option '--no-beep' ?? It reads defaults even when told not to do so?
[11 Oct 2016 16:49]
Tsubasa Tanaka
I seem --no-defaults should be the first place of the other options. `mysqldump --version --no-defaults` should be `mysqldump --version --no-defaults`
[11 Oct 2016 16:50]
Tsubasa Tanaka
A typo of `mysqldump --no-defaults --version`..
[11 Oct 2016 17:39]
MySQL Verification Team
Duplicate of http://bugs.mysql.com/bug.php?id=70166 which was filed as private.
[11 Oct 2016 17:50]
Peter Laursen
can you please tell: 1) What did bug70166 fix a) the Installer created a stupid and disturbing my.ini b) --no-defaults option not having effect ?? (because I want to file a 2nd bug report for the other issue than the one fixed) 2) what 'security issue' does this bug have that implied that it should be private?
[14 Oct 2016 12:20]
MySQL Verification Team
Thank you for the feedback! As suggested in earlier comments, workaround is to ignore all my.ini when running the command: mysqldump --no-defaults -uroot db > db.sql
[14 Oct 2016 12:23]
MySQL Verification Team
Duplicate of Bug #70166 but the other being private can't make duplicate for now. Both will be closed together when fixed
[14 Oct 2016 12:37]
Peter Laursen
You did not reply to my question "What did bug70166 fix?" .. so I posted http://bugs.mysql.com/bug.php?id=83386
[4 Nov 2016 20:56]
Christine Cole
Fixed as of the upcoming MySQL Installer 1.4.18 release, and here's the changelog entry: MySQL servers installed with MySQL Installer returned the "mysqldump: [ERROR] unknown option '--no-beep'" error message when the mysqldump client utility was invoked. This fix relocates the no-beep option entry within the my.ini file. Thank you for the bug report.
