MySQL Bugs: #39923: Current time zone table unavilable for mysql on windows

Bug #39923	Current time zone table unavilable for mysql on windows
Submitted:	8 Oct 2008 10:30	Modified:	2 Jun 2009 18:25
Reporter:	Jonathan Aldridge
Status:	Closed
Category:	Server: Packaging	Severity:	S3 (Non-critical)
Version:	All	OS:	Microsoft Windows
Assigned to:	Georgi Kodinov	Target Version:	5.0+
Tags:	timezone
Triage:	Triaged: D2 (Serious)

Description:
There is no way to get current mysql.time_zone tables for a windows mysql installation.

The tables provided at: 
http://dev.mysql.com/downloads/timezones.html
are two years out of date.

And the tool suggested to generate these tables from a zoneinfo file is not available in
the windows build.

How to repeat:
Following the instructions at:
http://dev.mysql.com/downloads/timezones.html

gives out of date tables.

Not strictly a bug, but not sure where else to put this.

Thank you for the reasonable feature request.

As alternative you could try to generate system tables on Cygwin. One have compile MySQL
on Cygwin herself to do it.

As others(like PHP) have already updated to the newer version of timezones . MySQL should
also release the latest version of the table at the earliest.

2009e timezone file generated using the tool in 5.0-bugteam

Attachment: timezone-2009e.zip (application/zip, text), 442.41 KiB.

Hi, thanks for the quick reply.
The tables you provided don't take leap seconds into account.In my project i need to take
care of leap seconds also. So please provide a set of tables with leap seconds enabled.

I have tried to generate the table for windows myself. See the attachment.
What i have done is this. I downloaded the code and data from
ftp://elsie.nci.nih.gov/pub/
Then created linux binary which resulted in 3 set of zoneinfo files namely 
a)zoneinfo b)zoneinfo-leaps c)zoneinfo-posix . I used zoneinfo-leaps
and then used these commands,
1. mysql_tzinfo_to_sql /var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/ | mysql -u root
mysql
2. mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql 

to load the tables and then just copied the tables to use on windows machine.

But there are some problems i faced.
1.I got these warning messages when i used mysql_tzinfo_to_sql 

Warning: Unable to load '/var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/Asia/Riyadh87' as
time zone. Skipping it.
Warning: Unable to load '/var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/Asia/Riyadh88' as
time zone. Skipping it.
Warning: Unable to load '/var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/Asia/Riyadh89' as
time zone. Skipping it.
Warning: Unable to load '/var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/Mideast/Riyadh87'
as time zone. Skipping it.
Warning: Unable to load '/var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/Mideast/Riyadh88'
as time zone. Skipping it.
Warning: Unable to load '/var/www/tz2009e/linuxbuild/etc/zoneinfo-leaps/Mideast/Riyadh89'
as time zone. Skipping it. 

2.
In the command 
mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql  

I dont know which file to use as tz_file. so used zoneinfo-leaps/GMT.
Anyways independent of which file i am using here its generating exactly same table. 

3. I am not exactly sure which of the three zone info folders (ie. out of zoneinfo,
zoneinfo-leaps and zoneinfo-posix ) should i used zoneinfo-leaps.

So because of this i am not sure the tables i have got are perfect or not.
Any help is appreciated.

timezone 2009e tables for windows

Attachment: tables.zip (, text), 446.43 KiB.

Hello Georgi!

Note that files provided by you include time zones without leap seconds support, while
previous versions of tables which are available from our site include time zones with
leap seconds. Also it seems that your package misses some information from
time_zone_leap_seconds table.

So I am asking to rebuild tables taking into account the above issues and other issues
discussed on IRC.

Meanwhile new version of tzdata package (2009g) is available.

Thanks for your efforts!

timezone-2009g.zip with proper leap seconds support

Attachment: timezone-2009g.zip (application/zip, text), 440.39 KiB.

Hello, Georgi!

This new version of tables contains correct leap seconds table. But it looks like time
zone descriptions itself do not use this information. E.g. Time_zone.Use_leap_seconds is
set to 'N' for its time zones and transition times do not take into account leap seconds.
I don't think we can claim that these are tables with "proper leap seconds support".

Please let me know if I am missing something.

now with Use_leap_seconds on

Attachment: timezone-2009g.zip (application/zip, text), 440.38 KiB.

updated file

Attachment: timezone-2009g.zip (application/zip, text), 449.38 KiB.

Hello Georgi!

The last version of tables which you have provided looks fine to me.

IMO it is OK to publish it in our download area.

Thank you once again!

Updated file published to the web site.

Noted in 4.1.26, 5.0.83, 5.1.36, 6.0.12 changelogs.

The time zone tables for Windows available at
http://dev.mysql.com/downloads/timezones.html
have been updated.