time_zone issue: loading timezones in mysql

[grel]

We run php8 on a windows server.

Per default (as I read in different articles by now) the 5 time_zone tables in the mysql DB are empty.

So I got the .frm .myd .myi files from https://dev.mysql.com/downloads/timezones.html

Then I overwrote the files in C:\Program Files\MySQL\MySQL Server 5.5\data\mysql

I clearly see in win explorer they have some data in it.

Next I restarted the mysql DB but for some reason the tables remain empty when exploring them in phpmyadmin??

Does anybody has a clue why they don't have the data??

 

the step by step articles I followed:

https://www.geeksengine.com/article/populate-time-zone-data-for-mysql.html

https://www.raymondcamden.com/2012/02/27/How-to-add-MySQL-time-zone-tables-on-Windows

 

[dianacrown88]

The install will have put a vanilla version of the mysql database onto your system. Thats the database MySQL uses to record databases/user/tables etc. So its a bit like replacing the registry in windows. Files may still be there but MySQL has no knowledge of them.

[dianacrown88]

On 10/10/2022 at 2:54 PM, dianacrown88 said:

The install will have put a vanilla version of the mysql database onto your system. Thats the database MySQL uses to record databases/user/tables etc. So its a bit like replacing the registry in windows. Files may still be there but MySQL has no knowledge of them. https://buyessayscheap.org/

serverTimeZone definition was introduced in mysql jdbc connectors versions 5.1 ahead. until version 8 it could be ignored with useLegacyDatetimeCode=true , which in conjunction with useJDBCCompliantTimezoneShift=true would make the application get the database time zone on every connection. In this mode GMT time zones such as 'British Summer Time' would be converted to the internal java/JDBC format.