Re: Workbench export : constraints error
I don't see you executing the SET commands. It is important that the Foreign Key checks are turned off because there might be tables referencing each other.
If you would execute the full script that WB exports, it should throw no error. If you only want to execute a part of it, please copy the SET commands from the beginning and end to your excerpt.
Hope that helps,
Mike
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Subject
Views
Written By
Posted
9551
January 30, 2009 05:39AM
3694
January 30, 2009 10:37AM
4104
January 30, 2009 11:02AM
Re: Workbench export : constraints error
3567
January 30, 2009 11:13AM
3667
January 30, 2009 11:27AM
3283
January 30, 2009 01:08PM
3347
January 31, 2009 10:08AM
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.