Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I want to be able to create a PDF or an image of a MySQL database. It should have one box per table and each box should list all the columns in the table. I don't need lines going between various forgein keys or show info on default types or even the type of the column.

Is there such an open source programme to do this?

share|improve this question

4 Answers 4

up vote 0 down vote accepted

Looks like there is no one good way to do this

share|improve this answer

You don't say just how much detail you want but have you considered using the MySQL "show tables;" command? You can use it to create a chart of the fields but it doesn't tell you anything other than the field name.

share|improve this answer

You may try MySQL Workbench to create a diagram by importing the sql create statements of your database.

share|improve this answer

It's not open-source and not free (license is 99 USD):

DBDesc

dbdesc is a powerful tool to help you document your databases. It can produce detailed documents describing your databases.

[...]

Now dbdesc includes a built-in report engine and report viewer to easily browse database documentation. This report can be exported to PDF.

Here is a table containing all features for the different database platforms.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.