Bug #72498 Request for mysqldump's new "--grants" option
Submitted: 1 May 2014 8:57 Modified: 6 May 2014 4:30
Reporter: tsubasa tanaka (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.6.17 OS:Any
Assigned to: CPU Architecture:Any
Tags: grants, mysqldump

[1 May 2014 8:57] tsubasa tanaka
Description:
This is feature request of mysqldump's new option "--grants".
It behave like "--triggers" dumps CREATE TRIGGER statements and "--routines" dumps CREATE PROCEDURE statements, "--grants" will dump GRANT statements.

It is useful for restoring different table definition in mysql schema.
For example, upgrading 5.5 to 5.6(5.6's mysql.user have password_expired column, but 5.5's does not)

How to repeat:
This is feature request.

Suggested fix:
See attached patch.
[1 May 2014 8:58] tsubasa tanaka
patch based MySQL 5.6.17

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

Contribution: mysql-5.6.17_mysqldump_grants.patch (application/octet-stream, text), 4.96 KiB.

[6 May 2014 4:30] Erlend Dahl
Thank you for the feature request and your contribution.