Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: MySQL and time zones
PostPosted: Wed Sep 20, 2006 12:18 pm 
Offline

Joined: Thu Jul 27, 2006 11:58 am
Posts: 254
Quote:
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group