In order to get approval, we need a graphical diagram. Pierre suggest schemaspy. It turns out that a couple of dependencies were required:

	
Apparently, SchemaSpy
	
It needs Graphviz installed
	
Also, database driver in our case JDBC-MySQL driver
	
Luckily, I have it installed on my windows machine with ColdFusion earlier, located at
	
C:\ColdFusion2016\cfusion\lib\mysql-connector-java-5.1.38-bin.jar

Migrate mysql DB from linux (wine) to windows desktop. Before doing this, I needed to drop all tables in the database first. It turns out a scripting way works for linux. For windows, it is easier to drop the database and re-create the database.

[li11@ehscmplp11/wine ~]$ mysqldump -u li11 -ppassword mirDB > ~/mirDB.sql
C:\Users\li11>mysql -u root -ppassword ratemirs < x:\mirDB.sql

My command to run SchemaSpy was:

java -jar Downloads\schemaSpy_5.0.0.jar -dp C:\ColdFusion2016\cfusion\lib\mysql-connector-java-5.1.38-bin.jar -t mysql -db RATEmiRs -host localhost -u li11 -p nopassword -o X:\project2016\microRNADB\diagram\

Interesting enough, the command involves both “windows” local and “network” drive.

10/18/2016

I did not know what was going wrong, but when I tried the same command, it failed then became okay. Just to watch out for it.