CODEWITHSUNDEEP
mysqlmysql-workbench
Nav Kumar
Nav Kumar

Reputation: 141

how to get script of existing schema in mysql workbench

I am using mysql5.6 workbench. I have a schema and many tables in this schema. Now I need to get the complete schema on my other system for which I need the script. I created all the tables without running the script so I don't have script. But now I want to generate the script from the workbench so that I can run it on another system.

please suggest me how I can get this script from mysql workbench 5.2CE.

Also please help me to get it out in a .sql file format script.

Upvotes: 4

Views: 19036

Answers (2)

Pawan
Pawan

Reputation: 443

Select the File, Export, Forward Engineer SQL CREATE Script menu item to start the Forward Engineer SQL

Get more details here

Upvotes: 2

Martin
Martin

Reputation: 5322

  1. Right click on the schema
  2. Select "Send to SQL Editor"
  3. Select "Create statement"

If you want to generate a complete create script (i.e. including the tables), select the schema AND all the tables (hold down Ctrl to multiselect), then follow steps 1 through 3.

Upvotes: 8

Related Questions