To create ER diagram from db schema you can use SchemaSpy.
Here are few steps:
1. Download SchemaSpy
2. Install flowing:
- Java
- JDBC MySQL Connector
- Graphviz (and dot program, which is part of GraphViz)
3.Execute command in console
C:test>java -jar schemaSpy_5.0.0.jar -t mysql -o folderWhereCreate -host dbHost -db dbName -u dbUser -p dbPassword -dp mysql-connector-java-3.1.13-bin.jar
ps: You can download all in one archive
References:
Automate the generation of your developer and user documentation
