Bug #92965 mysqldiff add AUTO_INCREMENT without setting value
Submitted: 26 Oct 2018 12:04 Modified: 26 Oct 2018 18:04
Reporter: salem ardjoune Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:1.6.1 OS:Any
Assigned to: Bogdan Kecman CPU Architecture:Any

[26 Oct 2018 12:04] salem ardjoune
Description:
I want to use mysqldiff to compare the schema of two sql tables (just the schema, not the data).
I run the command on two tables (table1 and table2), which are exactly the same except that table one as a column that has AUTO_INCREMENT option but the same column in table2 doesn't have this option. 

I discovered that if I don't use the --skip-table-options, table that are the same but that have different AUTO_INCREMENT values will fail, so I must use this option. However, with this option, when comparing table1 and table2 will fail but the transformation doesn't add AUTO_INCREMENT. Is there an option to compare only the structure (including AUTO_INCREMENT) but not the values?

How to repeat:
Use mysqldiff with the option --skip-table-options to compare two tables which have the same structure, with AUTO_INCREMENT activated for one table and deactivated for other
[26 Oct 2018 18:04] Bogdan Kecman
The binary that was maintained by us is no longer being developed. It's now under "sustaining support" only so you are encouraged to move to MySQL Shell
https://dev.mysql.com/doc/mysql-shell/8.0/en/

If you want to continue using mysqldiff you might want to report a problem here: https://github.com/aspiers/mysqldiff/issues

all best
Bogdan