Re: Re: TZ setting

[Victoria Reznichenko]

Gerald,
Thursday, April 18, 2002, 1:52:25 AM, you wrote:

GRJ Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up?

GRJ I have read the manual on this, and tried various combinations, but haven't
GRJ hit the right syntax.

No, you can't specify timezone in the my.cnf(my.ini) file ... (you can
find some more info about it in the Paul's book, page 419).
On Windows you can change timezone setting TZ environmental variable.

GRJ Gerald Jensen




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: TZ setting

[Gerald R. Jensen]

Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up?

I have read the manual on this, and tried various combinations, but haven't
hit the right syntax.

Gerald Jensen

- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 17, 2002 8:14 AM
Subject: Re: TZ setting


DL,
Wednesday, April 17, 2002, 1:37:15 PM, you wrote:

DN Manual References: A.4.6 Time Zone Problems, F Environment Variables,
DN and 4.1.2 my.cnf Option Files, but no examples or real explanation of
DN use.

DN Has anyone made use of MySQL's TZ setting?

DN Can the TZ setting be used to run a db in a different time zone to the
DN underlying OpSys?

Run mysqld with --timezone=# option ...
Look at:
# mysqld_safe --timezone=EET 
mysql select now();
+-+
| now()   |
+-+
| 2002-04-17 12:59:06 |
+-+
1 row in set (0.01 sec)

# mysqld_safe --timezone=GMT 
mysql select now();
+-+
| now()   |
+-+
| 2002-04-17 10:01:38 |
+-+
1 row in set (0.00 sec)

DN (Windows and/or Linux)
DN Please advise,
DN =dn




--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php