Mysql timezone on windows 7 not updated

Question

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 1

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.