Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
None
-
CentOS 7
Description
We use:
mysqldump --compact --no-data
|
to extract all the tables definitions.
We then strip the AUTO_INCREMENTS with SED:
sed \'s/ AUTO_INCREMENT=[0-9]*//g\' |
The output is then hashed in order to check table version across different servers.
We realize that few time the comparison doesn't match because INDEX are dumped by: "indextype ASC, creation ASC" instead of "indextype ASC, indexname ASC".
So 2 identical table structure will be different just because a developer added an index before another. This is weird.
Is it possible to force the dump of the indexes by type and then by alphabetical order?