-noschema not working

  • Cecil Westerhof

    Cecil Westerhof - 2011-04-27

    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:
    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.



Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks