Jump to content

time_zone issue: loading timezones in mysql


Recommended Posts

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:




Link to comment
Share on other sites

  • 4 weeks later...
  • 3 weeks later...
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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.