Bug #35224 mysqldump --help is very confusing
Submitted: 11 Mar 2008 16:07 Modified: 6 Mar 2010 23:21
Reporter: Susanne Ebrecht Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:5.1-bk OS:Any
Assigned to: CPU Architecture:Any

[11 Mar 2008 16:07] Susanne Ebrecht
Description:
I wanted a mysqldump with separate insert statements for every row.

$ mysqldump --help
...
 -e, --extended-insert 
                      Allows utilization of the new, much faster INSERT syntax.
...

Ok, this means without -e it won't make the "new" INSERT syntax.

$ mysqldump mydb.testdb > foo

Result: Also without the "-e" it takes the "new" INSERT syntax.

I figured out that I need: --skip-extended

But this isn't documented at mysqldump --help

How to repeat:
$ mysqldump --help

Suggested fix:
Add documentation for mysqldump --skip-extended

Add a sentense that "this is default behaviour" at -e
[11 Mar 2008 17:49] Chad MILLER
patch and example output

Attachment: p35224 (application/octet-stream, text), 17.01 KiB.

[12 Mar 2008 18:58] Jim Winstead
please have someone in docs review the added text to make sure they are happy with it.
[12 Mar 2008 20:07] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/43879

ChangeSet@1.2601, 2008-03-12 16:06:07-04:00, cmiller@zippy.cornsilk.net +3 -0
  Bug#35224: mysqldump --help is very confusing
  
  The presence of "--skip" parameters is obscure, when it should be
  obvious from the text.
  
  Now, for boolean options, when they're default to ON and the --skip
  is more useful parameter, then tell the user of its existence.
[14 Mar 2008 16:01] Chad MILLER
Queued to 6.0-build.
[28 Mar 2008 11:10] Bugs System
Pushed into 6.0.5-alpha
[22 Apr 2008 18:10] Paul DuBois
Noted in 6.0.5 changelog.

For boolean options, the option-processing library now prints 
additional information in the --help message: If the option is
enabled by default, the message says so and indicates that the --skip
form of the option disables the option. This affects all compiled
MySQL programs that use the library.
[3 Nov 2009 9:23] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/89047

2904 Magne Mahre	2009-11-03
      Bug#35224: mysqldump --help is very confusing
        
      The presence of "--skip" parameters is obscure, when it should be
      obvious from the text.
        
      Now, for boolean options, when they're default to ON and the --skip
      is more useful parameter, then tell the user of its existence.
      
      Backported from 6.0-codebase, revid  2572.14.1
[3 Nov 2009 9:24] Magne Mæhre
Backported to next-mr-runtime   (5.5.0)
[20 Nov 2009 12:57] Bugs System
Pushed into 6.0.14-alpha (revid:kostja@sun.com-20091120124947-yi6h2jbgw0kbciwm) (version source revid:jon.hauglid@sun.com-20090928163426-2lg1gofzz44xzzxf) (merge vers: 6.0.14-alpha) (pib:13)
[26 Nov 2009 15:24] Paul DuBois
Already fixed in 6.0.x.

Setting report to NDI pending push to 5.5.x (5.6.x?)
[6 Mar 2010 11:07] Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:jon.hauglid@sun.com-20090928163426-2lg1gofzz44xzzxf) (merge vers: 6.0.14-alpha) (pib:16)
[6 Mar 2010 23:21] Paul DuBois
Noted in 5.5.3 changelog.