WampServer

For years I have always downloaded the timezone files from [dev.mysql.com], extracted, then just copied them over to C:\wamp64\bin\mariadb\mariadb10.11.8\data\mysql, restarted, and my timezone tables were available to me.

First, mysql.com no longer provides the separate files at the link above, however, I found they are actually still there just no link is provided on the page. For example, [downloads.mysql.com], works and has the separate files.

With that said, copying those files in, like I have for years, does absolutely nothing any more. I use stuff like 'CONVERT_TZ' in my db statements and without the timezone information loaded these no longer work.

I'm not sure if the timezone tables have changed with the newer versions of mariadb or what is going on. Anyone have a solution? Surely I can't be the only one who needs the timezone information loaded in their db.

Well... it must be something that changed with the files because I was able to load the 2022 version of the timezone files and they worked fine.

It doesn't have much to do with Wampserver!

As far as Wampserver is concerned, I use : DateTimeZone::listIdentifiers or timezone_identifiers_list

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi,

Download the file: https://downloads.mysql.com/general/timezone_2024a_posix_sql.zip

Unzip it to obtain the file : timezone_posix.sql

Launch PhpMyAdmin.
Select database mysql
Select Import tab
File to import: browse computer to choose the file timezone_posix.sql
Import button at the bottom

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi,

For MariaDB it is the file zoneinfo.zip at https://mirror.mariadb.org/zoneinfo/ then PhpMyAdmin with the import file zoneinfo.sql.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons