Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Generate diagram from SQL script in MySQL WorkBench

Is there any possibility to create visual diagram from SQL script? I've my DB saved in MySQL on Localhost. And I want to visualize it. If this program cannot do that and you know about another, please tell me.

Thanks a lot;

like image 551
sczdavos Avatar asked Jun 09 '13 11:06

sczdavos


People also ask

How do I export a diagram from MySQL Workbench?

To export diagram go to menu, select File, then Export, select one of the available formats and provide folder and filename.

How do I import a SQL script into MySQL Workbench?

To import a file, open Workbench and click on + next to the MySQL connections option. Fill in the fields with the connection information. Once connected to the database go to Data Import/Restore. Choose the option Import from Self-Contained File and select the file.

Can we make ER diagram in MySQL?

While the community edition of MySQL Workbench does not include a simple feature for creating Entity Relationship diagrams, there is a way to do it. Tushar Soam documented it in Create ER Diagram of a Database in MySQL Workbench and it worked fine for me.


2 Answers

In the latest MWB 6.3 version you need to do the following

1) On the home page click on the ">" sign just below the label Models
2) It will show you to create EER diagram from either Database or SQL files

generate EER from DB or SQL Script

like image 74
user2720864 Avatar answered Sep 18 '22 23:09

user2720864


I have found answer here on official program website: http://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html

like image 23
sczdavos Avatar answered Sep 17 '22 23:09

sczdavos