tags:

views:

169

answers:

4
+1  Q: 

MySQL: How to study/analysis a MySQL DB tables relationships?

I'm given a MySQL DB that contain 108 tables. Is there a way or tool (software) to be able to see how these tables are connected (hopefully in a visual way) so I would be able to understand the usage of each table and how everything is working together. I'm accessing them through something called "MySQL Tools" -> "MySQL Administrator" with "Read Only" privileges.

Tables are all using InnoDB engine.

*I'm using Mac

+1  A: 

What you want is an ERD generator for MySQL. Do a google search on 'MySQL ERD' and plenty of free options pop up. I have not used this, however, I have heard decent things about DBDesigner

northpole  2009-10-28 14:17:22
DBDesigner looks very interesting, but no support for Mac!Any other suggestions?
MAK  2009-10-29 06:10:39
oh sorry, I didn't notice you said a MAC. The only time I ever develop on a Mac is through Windows on VMFusion. Is that an option for you?
northpole  2009-10-29 17:12:39
MAK  2009-10-31 07:43:44
+3  A: 

MySQL Workbench

ʞɔıu  2009-10-28 14:24:05
Cool! Last time I looked at Workbench it was Windows-only, but now I find they have Linux versions (ubuntu/deb) as well.
slashmais  2009-12-09 08:18:38
A: 

DB Visualizer
MySQL Workbench

Phill Pafford  2009-10-28 14:27:22
+1  A: 

this will only happen "automatically" if the database is using foreign keys. in my experience, most mysql-based applications do not so you might be out of luck there.

longneck  2009-10-28 14:53:20
That is, unfortunately (InnoDB vs MyISAM), true. However, I've heard that sybase powerdesigner attempts to reverse-engineer the triggers to find "declarative" (trigger-driven) relations. I don't know how successful it is at it, though.
shylent  2009-10-29 06:08:28
They are using the InnoDB engine which support the foreign key.
MAK  2009-10-29 06:17:35

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL