Create Database Model From Existing Database – MySQL Workbench

In case I’m not the only one who had trouble figuring out how to create a Database Model from an existing Database using MySQL WorkBench.

Database – MySQL
Database Tool – MySQL WorkBench v 6.1
Documentation – Database Modeling using MySQL Workbench

Steps to create a Model of an existing MySQL Database

  1. Launch MySQL Workbench
  2. From the Home window click the > icon to the right of Models at the bottom of the Window
  3. Choose “Create EER Model from Database”
  4. The Reverse Engineer Database Wizard starts
    1. Connect to your DBMS (Local instance –  TCP/IP in my case)
    2. Select Schema (the database you wish to model)
    3. Import the Table Objects
    4. Option “Place Objects on the Diagram” will auto generate the ERR diagram. If this doesn’t work for you run the wizard again and deselect then manually create the ERR Diagram via drag and drop of your tables.
  5. Save your model
  6. You can now add relationships and or modify tables
  7. That’s it !

Create Model From Existing Database

print

5 thoughts on “Create Database Model From Existing Database – MySQL Workbench

  1. Thank you. The Mysql documentation is vague on this task and needs improving. Your post probably saved me quite a few hours trying to figure this out for myself.

Leave a Reply

Your email address will not be published. Required fields are marked *