Bug #45232 Forward Engineer versioning with remote/local server
Submitted: 1 Jun 2009 3:24 Modified: 4 Jul 2009 17:30
Reporter: Greg Wright Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.1.12 Beta Rev 4000 OS:MacOS (v10.5.7, MacPro3,1, BootROM MP31.006C.B05, 8 processors, Quad-Core Intel Xeon, 2.8 GHz, 8 GB)
Assigned to: CPU Architecture:Any

[1 Jun 2009 3:24] Greg Wright 
Description:
The following error occurs when performing a Database | Forward Engineer to a remote machine that has the following version at Media Temple server hosting.

MySQL 5.0.45 via TCP/I

Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Default' at line 10

This has to do with semicolons (;), SET options, DROP IF EXISTS, CREATE TABLE IF EXISTS, and more.

How to repeat:
Perform Database | Forward Engineer to remote MySQL at Media Temple (dv) server.

Suggested fix:
Allow the options to either automatically identify the remote server version and produce script according to that version, or allow a manual selection to the destination version of the MySQL Server.
[1 Jun 2009 4:00] Greg Wright 
Using the Database | Synchronize Model works successfully doing an Update Source (vs. Update Model). There was no error executing this wizard, however, not all the objects were created on the server.
[4 Jun 2009 17:30] Valeriy Kravchuk 
Thank you for the problem report. Please, send the problematic .mwb file.
[4 Jul 2009 23: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".