Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do you create a model from an existing database on MySQL Workbench?

MySQLMySQL
0
Anonymous Posted

How do you create a model from an existing database on MySQL Workbench?

0 CommentsAdd a Comment

1 Answer

0
Farah Hassan

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 !
Select 0 CommentsAdd a Comment
What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.