FrankNatoli wrote:
> Need MySQL 5.1 to report date+time in UTC, even though I'm operating in
> U.S. Eastern Time. Once I insert "tz=utc" into my.ini in [mysqld]
> section, mysql will no longer start. Even tried "tz=EST5EDT" and mysql
> still would not start. Comment out the "tz" and "net start mysql"
> starts right up. Running WinXP SP2. What to do? Thanks.
>

TZ is an environment variable, not one in the my.ini file.

You can also start MySQL with the parameter --timezone=timezone_name to
set the timezone.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================