Show Mysql database structure in a diagram

Hangin' Around Joined: Aug 05, 2005 Posts: 29

Hi

I want to export my MySQL database structure in a format that is shows how it looks in a diagram type of look (almost like an organigram).

Is there a tool that does this?

PS someone told me that you can export from phpmyadmin in xml then import in Visio. Is this possible?

Site Admin Joined: Jun 04, 2004 Posts: 6432

Some versions of Visio have the ability to re-engineer databases via ODBC.

You might also want to take a look at an excellent, free tool: DBDesigner. It has some powerful tools for re-engineering, designing, and even comparing databases, starting with MySQL.

Posted: Thu Jun 01, 2006 10:33 am

thanks, I'll definately try DBDesigner