Bug #80810 Add ability to include missing objects in SQL output
Submitted: 21 Mar 2016 14:33 Modified: 21 Mar 2016 16:34
Reporter: Chuck Bell Email Updates:
Status: Verified Impact on me:
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:1.5.6 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[21 Mar 2016 14:33] Chuck Bell
Currently, when mysqldbcompare compares two databases and there are objects in one and not the other, it only reports the missing objects. When using the SQL output format, it would be nice to be able to see the SQL CREATE statements for those missing objects. 

How to repeat:
Compare two databases with at least one object missing. Use the SQL output and observe there is no CREATE statement for the missing object(s).

Suggested fix:
Please add this feature as an option.
[21 Mar 2016 16:34] MySQL Verification Team
Thank you for the bug report.
[2 Mar 2018 8:13] Lucio Fassio
The adding of --skip-table-options switch made the output of mysqldbcompare much more useful, it is a great utility.

The --create-missing-objects switch is missing instead and it forces me to create manually all the new objects wich is cumbersome and error prone, while the code to generate the SQL is probably available in the base MySQL classes.

Thanks in advance for your attention.

Lucio Fassio