MySQL, by default, does not “support” named timezones, therefore you
could get errors similar to
Unknown or incorrect time zone: 'Europe/Prague'. In fact, MySQL
just does not know the correct timeshift for this name and allows you to import
Run this command, where
root is the user name which has access
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
For MySQL 5.7+ download zipped SQL inserts from http://dev.mysql.com/…mezones.html
and run them in context of
For MySQL up to 5.6 download archive from http://dev.mysql.com/…mezones.html.
Unzip the archive and copy the files to your
mysql database in data
C:\<your mysql dir>\data\mysql).
If there is no way how to correctly setup MySQL database, you may use timezone offset configuration, which does not require named timezones support. See DateTime TimeZones Support chapter.