Setting the timezone

2003-10-13 Thread Juan Antonio Ruiz Zwollo
Hi. I am trying to change the timezone for MySQL (version 3.23.56) but it does not seem to work. Currently the timezone is set to MDT (I think its the default for MySQL). I added the following line to /etc/my.cnf at the [mysqld] section: set-variable = timezone=CST But when I try to stop and

Re: Setting the timezone

2003-10-13 Thread Mikhail Entaltsev
Hi, I am using these lines in my.cnf at [mysqld_safe] section. [mysqld_safe] timezone = GMT It works fine for me. Best regards, Mikhail. - Original Message - From: Juan Antonio Ruiz Zwollo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 13, 2003 5:38 PM Subject: Setting

Re: Setting the timezone

2003-10-13 Thread Mikhail Entaltsev
13, 2003 11:01 PM Subject: Re: Setting the timezone Hi: Do you use version 4 or 3? I thought that I need to use set-variable = timezone = CST for it to work under MySQL 3. Also, does anybody know if CST is recognized? Or do I have to use GMT-6 or something like that? Thanks for your time

Re: Setting the timezone

2003-10-13 Thread Paul DuBois
At 1:25 +0200 10/14/03, Mikhail Entaltsev wrote: Hi, Do you use version 4 or 3? I am using version 4.0.14. I thought that I need to use set-variable = timezone = CST for it to work under MySQL 3. MySQL docs: ...set-variable = variable=value This is equivalent to --set-variable variable=value