Windows 7上的MySQL时区未更新 [英] Mysql timezone on windows 7 not updated

问题描述

我正在使用 Windows 7

Mysql 5.5.15

运行set time_zone = "Europe/Moscow";

我得到Error Number: 1298 Unknown or incorrect time zone: 'Europe/Moscow'

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

我从这里 http://dev.mysql.com/downloads/timezones.html使用最新的时区表进行更新 但是在mysql服务器启动后，时区表仍然为空，并且该命令仍然返回相同的错误.

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?

推荐答案

解决方案:

对于那些面临相同问题的人-这就是我所发现的. 我跑了show variables like 'datadir' 并发现我的数据文件存储在另一个文件夹中:C:\ ProgramData \ MySQL \ MySQL Server 5.5 \ data \

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\

，最初我是替换C:\ Program Files ...文件夹中的文件.还有所需的文件.

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

所以最后一切都很好.

这篇关于Windows 7上的MySQL时区未更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！