1 click Mysql schema to diagram convert?

I have so many tables and FK relationships it is hard to keep track and visualze it all. Speard across m开发者_如何学JAVAultiple excel documents. I have it already entered in mysql but I want to output a data model diagram that links tables together along with all the FKs.

How to do it apart from manually having to do it? I am open to 3rd part tools as long as they are free.

Well I am using phpMyAdmin on my local server.

phpMyAdmin 3 has this Designer feature that shows you the linkages between various tables and its columns.

Take a look at the MySQL Workbench.

It's a free tool and offers a few nice features like forward and backward engineering and database synchronisation. I has a few bugs, but its the best tool for MySQL I know so far.