MySQL Bugs: #98815: database export/import not working

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:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0	OS:	MacOS
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	BuggedSchamaExport

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

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

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.

Regards,
Ashwini Patil

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