Have you ever tried to do a MySQL replication at a different timezone/SO and got the following error message at SHOW REPLICA STATUS? Well, there are two ways to solve this, Error ‘Unknown or incorrect time zone: ‘America/Cuiaba” on query. Default database: ‘glpi_tiab’. Query: ‘BEGIN’
If you are on Linux, you can run the following and solve the problem (after a restart of the service).
$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p
On Windows, I found it to be easier if you download the timezone instead of build/import your own. You can download from here https://dev.mysql.com/downloads/timezones.html.
use mysql;
source /path/to/file/timezone_posix.sql;
Well, that’s it for today. See ya.