Bug #47468 Workbench Export sql script deletes schema whene exists.
Submitted: 21 Sep 2009 7:26 Modified: 30 Oct 2009 17:05
Reporter: Robyn Chen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.2.3 OSS Alpha OS:Windows (XP SP3)
Assigned to: Alexander Musienko CPU Architecture:Any

[21 Sep 2009 7:26] Robyn Chen 
Description:
The script generated by the 'export' procedure deletes the schema when exists, and then recreate it. This wiped out all my 200k lines of data.

How to repeat:
File->Export->Forward Engineer SQL Create Script
Then select a table to recreate. Check out the lines about schema.

Suggested fix:
Version 5.2.2 Alpha works just fine.
[21 Sep 2009 7:51] Valeriy Kravchuk 
This problem can be related to the "fix" for bug #46706...
[23 Sep 2009 11:00] Susanne Ebrecht 
Many thanks for writing a bug report.

Verified as described.
[28 Oct 2009 20:31] Johannes Taxacher 
this was fixed in our repository and will be included in release 5.2.7
[30 Oct 2009 17:05] Tony Bedford 
An entry has been added to the 5.2.7 changelog:

The script generated by File, Export, Forward Engineer SQL CREATE Script dropped a schema if it existed and then recreated it. This resulted in loss of existing data.