MySQL Forums
Forum List  »  MySQL Workbench

Foreign Keys in *.SQL File
Posted by: gavin Greenwalt
Date: February 11, 2008 08:38PM

I'm having a problem with the export of my database. I imported it into the workbench just to get a better view of how it was layed out did a very small tweak to a table name. And then tried to export. But when I run the .SQL file that I export to create the new database... it gives me an error.

I think it's because it wants all of the ALTER TABLE ADD FOREIGN KEY commands run after the tables have been created. Is this true? Is there a way to set the mode so that it executes properly?

Options: ReplyQuote


Subject
Views
Written By
Posted
Foreign Keys in *.SQL File
3588
February 11, 2008 08:38PM
2371
February 11, 2008 10:20PM
2316
February 12, 2008 04:20AM


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.