MySQL Forums
Forum List  »  MySQL Workbench

Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?
Posted by: Al P
Date: December 09, 2008 06:26PM

This is probably a stupid question but I want to understand clearly.
Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?

I designed a schema and exported it with forward engineer SQL create script.
I am trying to import this into Yahoo web hosting.
The Yahoo web hosting environment supports only MySQL 4.1.14 and phpMyAdmin 4.3.11
I get the following when importing:

Error
SQL query:
SET @OLD_SQL_MODE = @ @SQL_MODE ,
SQL_MODE = 'TRADITIONAL';
MySQL said:
#1231 - Variable 'sql_mode' can't be set to the value of 'TRADITIONAL'

If I replace the traditional mode with ANSI, also on the import filter, then it fouls up at some later statements.

So my basic question is, will MySQLWorkbench produce only MySQL 5.0 compatible scripts? Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Will MySQLWorkbench produce only MySQL 5.0 compatible scripts?
2457
December 09, 2008 06:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.