tool to export DB schema graphically

[Romain GUINOT]

Hi guys,

Sorry if this is a bit off-topic, but I'd like to know if you can
recommend a tool to generate a graph of table/field relationships from
a given MySQL DB ?
I know MySQL Workbench does this, but it's been years since i've been
asked something like this, so there may be better tools that i
missed.

My only requirement is that it needs runs on Linux.

Thanks for any input,
Regards,
Romain.

[Baron Schwartz]

We have recently worked on a one-off tool for a specific customer that can generate such a graph from either foreign key relationships or from table and column naming conventions. It is not part of percona-toolkit and it is not generic/broadly usable, but it *can* be and it is a good start.
https://code.launchpad.net/~percona-toolkit-dev/percona-toolkit/pt-key-walker

[Morgan Pyne]

I've been using SchemaSpy (+ Graphviz) to generate full entity-relationship graphs. Very happy with the results, It produces HTML, CSS, Images + Imagemaps (giving you clickable interactive graphs).

http://schemaspy.sourceforge.net/

You can view the entire schema graph (for me it's quite large - recommend viewing that graph in a tool that allows panning and zooming), click into individual tables, display tables with one or 2 degrees of separation, and get a lot of other information also.

Regards,
Morgan

> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.
>

[Romain GUINOT]

Thanks both for the suggestions !

Cheers,
Romain.

PS : i wasn't emailed/notified about the replies, is there something i
should configure in the google group ?

On 2 avr, 23:11, Morgan Pyne <morgan.p...@gmail.com> wrote:
> I've been using SchemaSpy (+ Graphviz) to generate full entity-relationship graphs. Very happy with the results, It produces HTML, CSS, Images + Imagemaps (giving you clickable interactive graphs).
>
> http://schemaspy.sourceforge.net/
>
> You can view the entire schema graph (for me it's quite large - recommend viewing that graph in a tool that allows panning and zooming), click into individual tables, display tables with one or 2 degrees of separation, and get a lot of other information also.
>
> Regards,
> Morgan
>
> On 3/04/2012, at 2:08 AM, Baron Schwartz wrote:
>
>
>
>
>
>
>
> > We have recently worked on a one-off tool for a specific customer that can generate such a graph from either foreign key relationships or from table and column naming conventions. It is not part of percona-toolkit and it is not generic/broadly usable, but it *can* be and it is a good start.

> >https://code.launchpad.net/~percona-toolkit-dev/percona-toolkit/pt-ke...