homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Loading the MySQL Time Zone Tables questions.

5+ Year Member

Msg#: 4492013 posted 5:41 pm on Sep 6, 2012 (gmt 0)

hi all,

I want to load the empty time zones tables in the MySQL database on my server.

I have WAMP installed on my office Windows 7 x64 development machine. The MySQl docs say that the Windows OS does not have time zone tables. However, the MySQL WAMP installation on the Windows 7 machine does have a set of empty time zone files in the "\Program Files\wamp\bin\mysql\mysql5.5.20\data\mysql" directory.

It appears that the MySQL docs say that i can just move and copy over the empty time zones files in that directory with the "timezone_2011n_posix" files i downloaded from the MySQL site.

Is this correct?

I'm a little confused because there is a warning that says...
Do not use the downloadable package if your system has a zoneinfo database. Use the mysql_tzinfo_to_sql utility instead. Otherwise, you may cause a difference in datetime handling between MySQL and other applications on your system.
I think the warning does not apply to me because i think it is referring to the Windows system itself having a zoneinfo database and not the WAMP installation on the system - am i also correct in this assumption?



Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved