← Back to team overview

maria-discuss team mailing list archive

Timezones Table

 

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.

Thanks,
Ti.

Follow ups