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 and help. King regards, Juan Antonio ----- Original Message ----- From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> To: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 10:50 AM Subject: Re: Setting the timezone > 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 the timezone > > > > 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 start the daemon, it does not want to start: > > --------------------------------------- > > Starting mysqld daemon with databases from /usr/local/mysql/var > > 031013 10:04:04 mysqld ended > > --------------------------------------- > > > > It will only start if I remove the timezone line from my.cnf, but then the > > timezone stays at MDT. > > > > Thanks for your time. > > > > Kind regards, > > > > > > Juan Antonio Ruiz Zwollo > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]