Solved

visual representation of the dependencies using phpMyadmin

Posted on 2004-09-07
1
319 Views
Last Modified: 2006-11-17
Hello ..I am relatively new to Mysql .I am using phpMyadmin as the graphical client.The database I working right now is pretty complex(I did not desgign it).I was wondering if there is any feature in phpMyadmin wherein I can see the structure of the tables in graphical form ...something like
an ER diagram..(like we see in SQL ..and in some clents in Oracle)

I appreciate your time.Would go a long way in helping me understand mysql db in general
0
Comment
Question by:micro_learner
1 Comment
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
ID: 12007253
I don't believe there is anything in phpMyAdmin to do it.  Part of the problem is that the default table type for MySQL doesn't enforce foreign keys.  Unless you are using InnoDB, MySQL has no idea what tables are linked to each other.  AFAIK, you'll have to draw such a diagram by hand.  You might import the tables into some tool like Access that has a quasi-decent relationship diagram editor, so all you have to do is drag and drop on the relationships.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question