MySQL and time zones

Frequently Asked Questions
Locked
mikeb
Posts: 254
Joined: Thu Jul 27, 2006 11:58 am

MySQL and time zones

Post by mikeb » Wed Sep 20, 2006 12:18 pm

WARNING: TimeTrex was unable to set your time zone. Please contact your TimeTrex administrator immediately.
If you are using MySQL with TimeTrex you must ensure that you have the proper time zone support as described in the MySQL manual.

If you are using Linux, run this command:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql

If you are using windows, you need to download the latest time zone description files from:

http://dev.mysql.com/downloads/timezones.html

Then shutdown your MySQL server if its running, unzip the time zone description files to your MySQL database data directory, ie:

C:\Program Files\MySQL\MySQL Server 5.0\data\mysql

It should ask to overwrite files that already exist, say yes.
Start MySQL again and you should now have full time zone support.
Mike Benoit

Locked