I need to get mySQL database schema output in html format, so I started working on this with SchemaSpyGUI.
Now, when I click on Start SchemaSpy it generate with this errors :
Failed to query Graphviz version information with: dot -V java.io.IOException: Cannot run program "dot": CreateProcess error=2, The system cannot find the file specified
Using database properties: [D:\Saurin\mySQL\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mysql.properties
--
Failed to connect to database URL [jdbc:mysql://192.168.1.11/dbmsTest]
Note: I downloaded graphviz from : http://www.graphviz.org/Download.php
and set dot in environment variable too;
On Ubuntu Linux 14.04 I solved this just installing graphviz
:
$ sudo apt-get install graphviz
[...]
$ dot -V
dot - graphviz version 2.36.0 (20140111.2315)
Keep both schemaSpy_5.0.0.jar & mysql-connector-java-5.1.35.jar files in same folder and keep installed graphviz installed folder outside program files/program files(X 86).
EX:-D:\jars> java -jar schemaSpy_5.0.0.jar -t mysql -o output -host localhost -db cmltDB -u cmlt -p cmlt123 -hq -dp mysql-connector-java-5.1.35.jar -gv D:\Graphviz2.38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With