MySQL 5.6 on Windows 8.1 — Load Time Zone Tables

gesker

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.