Bug #98815 database export/import not working
Submitted: 3 Mar 2020 14:11 Modified: 17 May 2020 7:47
Reporter: Alain Trepanier Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0 OS:MacOS
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: BuggedSchamaExport

[3 Mar 2020 14:11] Alain Trepanier
When I export my database to a single file and re-import it, it fails. One of the reason is that the produces sql script don't have the right order of creation e.g. dependancies must be liste first.

Solution when creating the sql file:
   !. Create all the table and indexes
   2. Alter all of them to add foreign keys

How to repeat:

Suggested fix:
!. Create all the table and indexes
2. Alter all of them to add foreign keys

like you do in the reverse engineer feature
[17 Apr 2020 7:47] MySQL Verification Team
Hello Alain Trepanier,

Thank you for the bug report.
I tried to reproduce reported issue on Windows 10 using workbench 8.0.19 with a sample provided file but I am not seeing any issues at my end.
We would appreciate if you can provide before export steps i.e alter statements etc so that we can import earlier dump, run alter statement to make changes and then export before importing. Thanks.

Ashwini Patil
[18 May 2020 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".