LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 12-19-2005, 12:20 AM   #1
koyi
Member
 
Registered: Jul 2003
Location: Osaka, Japan
Distribution: Arch, Ubuntu
Posts: 421

Rep: Reputation: 31
Auto generation of MySQL schema diagrams?


Hi, guys. I need your advice here.

Instead of drawing the database schemas and then implement the database, I started off by implementing the database straight into MySQL scripts in a project. But now I need a diagramatic representation of the database for a presentation.

Are there any tools out there which can help generate the schema diagram automatically from a database?
 
Old 04-28-2007, 10:35 PM   #2
YAOMK
Member
 
Registered: Apr 2006
Location: Ft. Lauderdale
Distribution: FC7 and CentOS 5
Posts: 40

Rep: Reputation: 15
I'm aware this post is a couple years old. But being linuxquestions.org the knowledge base it is. I thought I'd take the time to answer;

What you are trying to do is called "reverse engineering" There are several programs often referred to as "Entity Relationship(ER) Modeling". To name a few, you have; Xcase, mySQL Maestro, Case Studio (now toad), and from the dark side you got MS Visio (Visio doesn't fully support mySQL, you will encounter problems dealing with restrictions on data types availiable). Besides the afore mentioned there are many other ER Modeling Programs.

Another point to make is that these programs often use the myODBC driver to connect with mySQL.
 
Old 11-01-2007, 07:25 AM   #3
Caysho
Member
 
Registered: Sep 2002
Location: Perth Australia
Distribution: OpenWRT, debian, Ubuntu
Posts: 135
Blog Entries: 18

Rep: Reputation: 15
Came across this while looking for software to reverse engineer the mythtv database because the schema details on the mythtv wiki are lacking IMO.
There is an ERD entry on wikipedia at http://en.wikipedia.org/wiki/Entity-relationship_model which references some more software.

There is a schema browser in TOra (supposed to have mysql support), but a quick install under ubuntu doesn't give me access.
A search for "tora mysql" returns a .rpm plugin, but I get a connection refused message from sourceforge if I try downloading it.
 
Old 07-24-2008, 06:45 AM   #4
colinkingswood
LQ Newbie
 
Registered: Oct 2003
Location: Cambridge
Distribution: mandrake 9.1
Posts: 11

Rep: Reputation: 0
schemaspy

http://schemaspy.sourceforge.net/

Not stricly an ER diagram, but it will produce some very useful digrams of your database structure. If you are using MySQL, then you need to name the columns appropraitly so it can guess the relationships.
 
  


Reply

Tags
diagram, engineering, mysql, reverse


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto backup of www and mysql critical Linux - Software 6 08-18-2005 03:13 AM
Auto create user, mysql and ftp haze Linux - General 1 04-12-2005 11:10 AM
Partition Schema tomap Linux - Newbie 4 10-10-2004 02:53 PM
Partition Schema bmagill Slackware - Installation 3 05-27-2004 01:20 PM
Auto-generation of configure files in Kdevelop bigredgiant1 Programming 0 04-11-2004 02:46 PM


All times are GMT -5. The time now is 10:24 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration