Mysql timezone for Windows 7 not updated

Question

I am using windows 7

Mysql 5.5.15

running set time_zone = "Europe/Moscow";

I get Error Number: 1298 Unknown or incorrect time zone: 'Europe/Moscow'

I am updating the timezone tables using the latest one http://dev.mysql.com/downloads/timezones.html but after starting the mysql server the timezone tables are still empty and the command still returns the same errors.

Has anyone encountered a similar problem?

Answer 1

Decision:

For those who are faced with the same problem - this is what I found. I ran show variables like 'datadir' and found out that my data files are stored in a different folder: C: \ ProgramData \ MySQL \ MySQL Server 5.5 \ data \

C:\Program Files.... .

, .

Answer 2

Try:

SET GLOBAL time_zone = <timezone>;

Answer 3

, .

• MySql 5.6

timezone_2016f_posix.zip ,

, yourDrive:\mysql\data\mysql

• MySql 5.7 +

timezone_2016f_posix_sql.zip ,

, . YourDrive:\mysql\data\mysql

zip http://dev.mysql.com/downloads/timezones.html

.. mysql mysql MySql, XAMPP, : yourdrive:\Xampp\mysql\data\MySQL

,