Hello, again.

It seems today is going to be my day of asking you questions about things. Hooray!

So, does anyone know of a good, free tool that will do a nice little UML diagram type thing from a mysqldump-esque SQL schema? The MySQL tool is a bit shit, to be honest (there are several UI bugs, it's crashed on me a few times, and frankly, I don't think Java is up to drawing all those boxes at once).

I really don't see why this isn't easy to find - there are a load of different graph layout algorithms, and there must be loads of people who'd like to see a picture of their schema. But all of the diagramming things I've seen just clump all the tables together in one corner, or something similarly unuseful.

Any ideas?

(P.S. This one is less important than the mouse one, so if you have some kind of limit or quota of how many of my questions you're going to answer today, please contribute to the other thread.)

.meic | fruuti

Yeah, it's a young project, and the schema is still relatively small (20 or 30 tables). But it just overlapped them all terribly, and when I tried to zoom and pan the view, it would routinely get it wrong and I'd end up stuck somewhere I couldn't manipulate things properly.

As for the Java thing, we're thinking of the same thing, I'm just wrong, probably. I've not used it for a while, and remembered it being slow, and having a Java-y interface, for some reason.

.meic | fruuti

Heh, the windows installer just says "Setup could not be started. File not found" for me. I find this an unimpressive start, Peter Kelly.

And I've just tried the zip version, and though it starts, it won't connect to mysql (though I can do from the command line with the same details).

Boo!

.meic | fruuti

Same problems here.

Got around the install error by running as Administrator, but cannot for the life of me get it to connect to the MySQL server on my machine despite everything else working fine including PHP and the MySQL command line tools.

Tried replacing the libmysql.dll with the version distributed with MySQL 5, but it won't work with that version, just complains that it can't load the .dll.

Rubbish.

Gah, it wont even install at the moment on ubuntu, it seems it needs some fonts package which has been deprecated.

This certainly *used* to be a good tool, it seems it might have fallen by the wayside of late!