server timezone value 'X' is unrecognized or represents more than one timezone

Question

I'm trying to use SchemaCrawler against a MySQL database (version 5.6.17). The specific SchemaCrawler command I'm running from Windows CMD is:

schemacrawler.cmd -server=mysql -database=mydb -infolevel=minimum -command=list -loglevel=CONFIG -u=myname

From this command I'm getting:

... server timezone value 'X' is unrecognized or represents more than one timezone

Where X is a timezone string like ETD.

In another question, answer seems to be using serverTimezone parameter in the connection string. But, In my case, as a SchemaCrawler user, I cannot modify the connection string.

How should I proceed?

Try /usr/local/mysql/bin/mysqld_safe --timezone=UTC – KcFnMi Aug 31 '16 at 19:59 — KcFnMi, Aug 31 '16 at 19:59

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

SchemaCrawler offers an alternate version of the command-line, where you can use the database connection URL as described in the other question that you mention. Simply substitute -database=mydb with -url=....

Sualeh Fatehi, SchemaCrawler

edited May 23 '17 at 11:48

Community

1
1

answered Sep 01 '16 at 12:59

Sualeh Fatehi

4,700
2
24
28

server timezone value 'X' is unrecognized or represents more than one timezone

1 Answers1