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;
To export diagram go to menu, select File, then Export, select one of the available formats and provide folder and filename.
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.
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.
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
I have found answer here on official program website: http://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With