How Do I Generate Database Scripts In Mysql Workbench 6.1

Question

0.00/5 (No votes)

See more:

Hi friends.
I have good knowledge on MS SQL Server but i am new to MySql.
As we can generate scripts of entire database in sql server management studio,
and now I am using MySql Workbench 6.1 , and i want to generate entire scripts(tables,stored procedures,functions,etc) of a hosted database. I googled and i found something like we can do this through Forward engineering. But I can't see the Forward Engineering Option in MySqlWorkbench 6.1.

Please guide me.

Thanks in Advance
-Sameer

Posted 1-Aug-14 21:15pm

sameer549

Updated 29-Aug-17 21:57pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2014-08-02T04:45:00

Solution 1

Read this : http://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html[^]

Posted 2-Aug-14 4:45am

Mehdi Gholam

Comments

sameer549 4-Aug-14 3:35am

Hi Mehdi, thanks for ur reply, i have already gone through this link, but i didn't found File->Export->Forward Engineer SQL CREATE Script option in workbench 6.1 . However i generated script using right click option by selecting all the tables,and stored procedures.

Member 13385100 · Answer 2 · 2017-08-29T21:57:00

For MySql Developer, please follow following steps to generate the Script.

1=> Tools>Data Base Export> then will shown a popup.

2=> After PopUp do slelect the connection of databse where it needs to be moved, and
and Browse the Path where scripted .txt folder needs to be saved.

3=> then follow each steps with 'Next'>'Next'... option.. with all selected and
checked option( as per as requiremnt like, wether table,procedure,vies... only need to be generated in script).

4=> then at last click on 'Finsih' botton and then try to chekc the .txt script folder where it has been saved.

Note:- Please go through option you will get what steps you need to follow as per as requiremnt.