MySQL Workbench EER diagram creation

mysql mysql-workbench eer-model
andthereitgoes picture andthereitgoes · Jan 26, 2011 · Viewed 7k times · Source

There are two issues here regarding MySQL Workbench.

Is there a way to update an existing EER diagram with newly created DB tables, so that the EER diagrams automatically reflects the new tables AND their relationships.

OR

Is there a way to auto create the relationships between the table while creating a new EER diagram from an existing database?

I have about 70 tables in an existing database. So creating the relationship links between every table might be quite time consuming and not very productive.

If none of the above is possible, is there any tool out there which would allow me to create an EER diagram with all the relationship paths in place with in the diagram from an existing database.

Answer

Rahul Prasad picture Rahul Prasad · May 24, 2011

Use the designer feature of phpmyadmin (version 2.10.0 or newer). It automatically does what you want.

Although my MySql-workbench does automatically creates relationship.

If you can upload the db-dump it would be helpful.

Are you using innodb or MyIASM?

Related questions

How do I enlarge an EER Diagram in MySQL Workbench?

I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. Does anyone know how to enlarge it to two or more pages?

Read More
How to copy table between two models in Mysql workbench?

I am doing some databese thing, I need copy one table from one model to another, but i try many ways there no effect. Is there any way for doing this?

Read More
mysql workbench error opening EER

I'm having a lubuntu-64bit and installed MySQL-workbench to open the EER model. but it just doesn't open up.. It shows error Error unserializing GRT data error unserializing object (invalid struct) The same EER file opens fine in windows.. I'm …

Read More