SEO

#1 (**permalink**) 02-28-2008, 08:32 AM

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.

#2 (**permalink**) 02-28-2008, 08:32 AM

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
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

my.ini timezone