how to get script of existing schema in mysql workbench

Question

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.

nandhp · Accepted Answer · 2014-01-21 20:03:19Z

8

Right click on the schema
Select "Send to SQL Editor"
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.

edited Jan 21, 2014 at 20:03

nandhp

4,8772 gold badges34 silver badges42 bronze badges

answered Oct 7, 2013 at 12:36

Martin

5,4023 gold badges20 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nav Kumar Over a year ago

i want the whole script of al tables so please suggest me hopw to get the scripts of all tables

Martin Over a year ago

@NavKumar Ok, then you will have to select all the tables in the schema and select before doing step 2 and 3

Pawan · Accepted Answer · 2015-02-23 08:32:13Z

2

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

Get more details here

answered Feb 23, 2015 at 8:32

Pawan

4436 silver badges30 bronze badges

Collectives™ on Stack Overflow

how to get script of existing schema in mysql workbench

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related