← Back to team overview

maria-discuss team mailing list archive

Re: Timezones Table


Hi, Kurniadi!

On Jun 12, Kurniadi Asrigo wrote:
> Hi,
> I am following the instruction to update the timezone table from MySQL:
> https://mariadb.com/kb/en/library/time-zones/
> And the file is downloaded from MySQL page. I got MariaDB from XAMPP, running on Window10. I downloaded the "timezone_2018e_posix_sql.zip<https://downloads.mysql.com/general/timezone_2018e_posix_sql.zip> - POSIX standard"
> https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html
> Once downloaded, I extracted the package into a directory. From the instruction, I executed the command:
> .\mysql_tzinfo_to_sql.exe C:\dev\xampp_download\timezone\timezone_posix.sql | .\mysql.exe -D
> mysql -u root -p
> Now, the timezone Table is all empty. I am wondering if I am missing a step or an option.

No, you're doing one step too many. mysql_tzinfo_to_sql converts OS
timezone descriptions (in the form of tzinfo files) into sql. According
to the manual page you've mentioned it should be used as

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

You downloaded timezone tables *already in SQL*. Quoting that manual
page, again
 If your system is one that has no zoneinfo database (for example,
 Windows), you can use a package that is available for download at the
 MySQL Developer Zone:


 *  To use a time zone package that contains SQL statements, download
    and unpack it, then load the package file contents into your
    existing time zone tables: 

    shell> mysql -u root mysql < file_name

Chief Architect MariaDB
and security@xxxxxxxxxxx