Missing time zones in WAMP MySQL
If you try to run for example
SET time_zone = 'Europe/Oslo' on the default MySQL database that comes with WAMP you might get an error saying the time zone doesn't exist.
Apparently this is because the
time_zone tables for some reason are empty.
How to fix
- Go to dev.mysql.com/downloads/timezones.html
- Download the POSIX standard Time zone description tables, version 2011n zip archive
- Extract the files and overwrite the ones in
C:\wamp\bin\mysql\mysql5.6.17\data\mysql, or whatever your equivalent path would be
- Restart MySQL
Setting the time zone should now work 🙂