Timezone tables for MySQL

Question

Where can I get the latest version of timezone tables for MySQL? I need them for the Windows version and all I could find was

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

But this is a stale 2011 version. I need the actual data for mysql.time_zone, mysql.time_zone_leap_second, mysql.time_zone_name, mysql.time_zone_transition, mysql.time_zone_transition_type.

Maybe someone from Linux world could share :)

I even downloaded the zoneinfo directory, but mysql_tzinfo_to_sql gives me only a bunch of nonsence like

Warning: <path> is not a regular file or directory

But of course it is.

Answer 1

The system tables is defined in: mysql_system_tables.sql, mysql_system_tables_data.sql and mysql_test_data_timezone.sql

You can view the source code at:

https://github.com/mysql/mysql-server/tree/5.6/scripts

You can change the branch according to your MySQL version.

Answer 2

Here goes tzinfo.sql.zip

Had to use a Linux VM.