How do I generate a SQL script from my diagram in MySQL Workbench?

mysql sql mysql-workbench
Don Rhummy picture Don Rhummy · Aug 6, 2013 · Viewed 34.3k times · Source

I've created an EER diagram with tables, foreign keys, etc in MySQL Workbench and now I want to generate a ".sql" script that will create this database. How do I do that?

Answer

Dirk McQuickly picture Dirk McQuickly · Aug 6, 2013

Try: File->Export->Forward Engineer SQL CREATE Script

Related questions

Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away …

Read More
MySQL Workbench: How to keep the connection alive

Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4 …

Read More
How to generate the whole database script in MySQL Workbench?

I want to take the whole database. Where do I find the database file? And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?

Read More