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.