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 on the command-line. Please note that --set-variable is deprecated since MySQL 4.0; as of that version, program variable names can be used as option names. On the command line, just use --variable=value. In an option file, use variable=value..." http://www.mysql.com/doc/en/Option_files.html IMHO the problem is that you have put timezone variable into [mysqld] section, but you need to put it into [mysqld_safe] section. But I am not sure. Check it, please. Best regards, Mikhail. ----- Original Message ----- From: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 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 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
