I am using:
java -jar schemaSpy_5.0.0.jar -t mysql -o library -host localhost -db information_schema -u user -dp mysql-connector-java-5.1.15/mysql-connector-java-5.1.15-bin.jar -noschema
But get:
Using database properties:
/net/sourceforge/schemaspy/dbTypes/mysql.properties
Gathering schema details…
No tables or views were found in schema 'null'.
The schema exists in the database, but the user you specified (user)
might not have rights to read its contents.
Another possibility is that the regular expression that you specified
for what to include (via -i) didn't match any tables.
0 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
Unable to determine if any of the schemas contain tables/views
What am I doing wrong?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Database schema. This is optional if it's the same as user or isn't supported by your database.
Use -noschema if your database thinks it supports schemas but doesn't (e.g. older versions of Informix).
I'm not sure why you would be using -noschema with MySQL. It's not like older versions of Informix that provide incorrect metadata details.
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using:
java -jar schemaSpy_5.0.0.jar -t mysql -o library -host localhost -db information_schema -u user -dp mysql-connector-java-5.1.15/mysql-connector-java-5.1.15-bin.jar -noschema
But get:
Using database properties:
/net/sourceforge/schemaspy/dbTypes/mysql.properties
Gathering schema details…
No tables or views were found in schema 'null'.
The schema exists in the database, but the user you specified (user)
might not have rights to read its contents.
Another possibility is that the regular expression that you specified
for what to include (via -i) didn't match any tables.
0 schemas exist in this database.
Some of these "schemas" may be users or system schemas.
Unable to determine if any of the schemas contain tables/views
What am I doing wrong?
From the main site in describing -s schema:
I'm not sure why you would be using -noschema with MySQL. It's not like older versions of Informix that provide incorrect metadata details.
John