Bug #86636 dbcompare fails on foreign keys

• Submitted: 9 Jun 2017 13:29
• Modified: 12 Jul 2017 13:07
• Reporter: Alexander Kosarev
• Status: No Feedback
• 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

Description:
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?

Thanks,
Chiranjeevi.

[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".