Volder Volder - 1 year ago 202
MySQL Question

Mysql timezone on windows 7 not updated

I'm using Windows 7

Mysql 5.5.15


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 Source


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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download