Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Documenting a MySQL database model

an easy to reference document for your database

6:56 pm on Feb 16, 2012 (gmt 0)

Junior Member

5+ Year Member

joined:July 28, 2006
posts: 168
votes: 0

Hello, I am trying to find an ideal way to document a MySQL database. So far I've used MySQL Workbench's EER Diagram, imported my database, created all the relationships and commented on all tables, columns and relationships. There is a lot of good meta data in there and I was looking for a solution which would dump out the entire database organized by tables, columns and relationships with their respective comments.

Does anyone know of a tool which would be used for this? I'm sure I could write a PHP script to do this but it seems like I'd be re-inventing the wheel, there must be a proper way to do this.