Bug #86636 dbcompare fails on foreign keys
Submitted: 9 Jun 2017 13:29 Modified: 12 Jul 2017 13:07
Reporter: Alexander Kosarev Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Utilities Severity:S2 (Serious)
Version:1.6.1 OS:Ubuntu
Assigned to: Assigned Account CPU Architecture:Any

[9 Jun 2017 13:29] Alexander Kosarev
dbcompare fails to create tables with foreign keys while comparing DBs

How to repeat:
Create DB with 2 tables where table 'A' is linked to table 'B' with foreign key.
Try to compare this DB.
Will result in "Query failed. 1005 (HY000): Can't create table 'compare_A' (errno: 24)"

Suggested fix:
Tables should be treated in order of their dependencies on each other and not just by alphabetical order or their names.
[9 Jun 2017 14:36] Alexander Kosarev
Also is an issue with mysqldump.
phpMyAdmin however does the export right.
[12 Jun 2017 13:07] Chiranjeevi Battula
Hello   Alexander,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps,  create table statements etc. - please make it as private if you prefer) to confirm this issue at our end?

[13 Jul 2017 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".