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
connectionTz with value
which will use “offset” time zone setting. This will produce correct
datetime in PHP, however, your SQL functions may start returning incorrect
results, because MySQL won't be able to calculate proper difference between two
date time since in “offset” mode there are no day-light saving shifts.
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).