Volder Volder - 3 months ago 32
MySQL Question

Mysql timezone on windows 7 not updated

I'm 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 update the timezone tables using the latest from here http://dev.mysql.com/downloads/timezones.html
but after mysql server startup the time zone tables are still empty and the command still returns the same errors.

Does anyone faced similar problem?

Answer

Solution:

For those who faced the same problem - here 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\

and I was replacing files in C:\Program Files... folder initially. There was also the needed files present.

So finally everything went fine.