Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

-noschema not working

Help
2011-04-27
2013-05-29
  • 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?

     
  • John Currier
    John Currier
    2011-04-27

    From the main site in describing -s schema:

    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