MySQL Workbench - How to create a Model from existing scripts

When using MySQL Workbench you can create a Model from existing scripts. That is called "Reverse Engineering using a Create Script". Useful tool if you need to visualize and finishing modeling your data base.

Here are the steps:

Open MySQL Workbench, click on File --> Import --> Reverse Engineering MySQL Create Script

On Input and Options screen click on Browse and select your existing script. Then Click on execute...

When on Reverse Engineering Progress screen do no change anything there, just click on Next...
Then on the next screen , just click on Finish...

After clicking on Finish you'll see the EER Diagram screen. Here you just can drag and drop all the tables (on the left side) to the Diagram part (right part)

As soon as you start dragging and dropping tables to the Diagram side, you'll see the tables with their relationships. After that, you can export that diagram in any format you need.

As we can see in general, MySQL Workbench is a very intuitive software with tons of useful tools like this "Reverse Engineering MySQL". Feel free to play around with it and if you have any questions just post a comment or email me....