MySQL 5.6 on Windows 8.1 — Load Time Zone Tables

Ran into a pinch with my MySQL install on Windows 8.1. It seems the timezone data isn’t installed/loaded into the mysql timezone tables by default.

Here is the quick fix…

  1. Stop the MySQL Service
  2. Download the POSIX standard Time zone description tables from http://dev.mysql.com/downloads/timezones.html
  3. Unzip the downloaded file
  4. Copy its contents to C:\ProgramData\MySQL\MySQL Server 5.6\data\mysql
  5. Start the MySQL Service

There are more details here including directions for populating these tables on Linux.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s