quite note: generate a er chart and schema with schemaSpy

working on some complicated legacy db recently. wants to generate the er diagram to get to know details.

the mysql-workbench works very well, however it's slow in my setting. also the schema has little foreign key constrains as it is almost read-only db. the er reverse engineering feature in workbench is not that useful.

did some google, found the tool: schemaspy, it's standalone jar and easy to use.
http://schemaspy.sourceforge.net/

for mysql:
java -jar schemaSpy_5.0.0.jar -cp mysql-driver/mysql-connector-java-5.1.24-bin.jar -t mysql -host localhost -db dbname -u user -p pwd -o outputdir