[Rik Serpentier]

Hi,

When I create a new ER Diagram from a MySQL Schema located on my localhost MyEclipse draws the diagram perfect. Showing all relations, primary and foreign keys,…
When I want to create an ER Diagram of the same schema located at a server it shows me only the tables and the keys, no relationships are drawn.

The MySQL-install is on both machines 5.1.22. My localhost is a Windows Vista machine, the remote one is a Mac OS X Tiger

Ant clues ?

[Loyal Water]

Are you working on 64 bit or 32 bit version of vista ?

[Rik Serpentier]

I am working a 32-bit Vista.

[Loyal Water]

MySQL supports two different table formats. The older/faster one is called “MYISAM” and does NOT support foreign keys or any kind of key relationships.
MySQL also supports InnoDB, which is slower, but does support “Referential integrity”, like foreign keys.

I guess the report database that you are trying to render in the ER Diagram, is using MYISAM so there are no relationships to display.

[Rik Serpentier]

All tables are defined as InnoDB-tables. If you want I can send you the create-statements.

[Author]

Posts