Mike Jennings <[EMAIL PROTECTED]> wrote on 01/28/2005 07:57:06 AM: > Hello, > > I am looking to export a mysql database to a gui type interface. > Basically i'm looking at a big database and I wanna dump it to a > webpage/uml where I can add notes on what each table is and what it > does, even just dumping to a webpage would be fine cause i can edit > from there. > > is there anything like this? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
Mike, With all due respect, web pages (HTML documents and their ilk) are generally information that is simply consumed by a visitor to the site and are rarely used as control or design documents. UML documents (use cases, sequence diagrams, etc) are generally not as good at database schema modelling as ER diagrams. So, since your choice of output media seems inappropriate to me for the task you describe, I will have to guess at what I think you want to accomplish. What it sounds like to me is that you want to have some way to fill in the COMMENT information for each table (and possibly even for each field) in order to document what each of them represents. You can do that manually with ALTER TABLE statements and you should be able to do that through any GUI-type database administration program. Once you fill in the COMMENT information, I know you can quickly get a simple text dump of just your database schema (all of the CREATE xxx statements, not the data) by calling the utility program mysqldump with the correct options. Have you looked into using the MySQL Administrator yet? It's a GUI program that should do most of what you want (I know it doesn't diagram but it's somewhere to start). You will have to search around to find some other ER-based GUI administrator tools because I can't think of any off the top of my head (sorry! no coffee yet!). Maybe others on the list will recommend some? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
