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.
That's correct. --timezone is a mysqld_safe option, not a mysqld option.
Best regards, Mikhail.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]