I’ll keep this short. Let’s say you run “mysql> show slave status\G” and you see the following error:
Last_Error: Error 'Unknown or incorrect time zone: 'Etc/UTC'' on query. Default database: 'db_name'. Query: 'INSERT INTO table SET column = CONVERT_TZ('2009-01-24', '-8:00', '+00:00')'
It’s a simple fix. Exit out of MySQL and run the following command – this works on Redhat, I’ve not tried it on other flavors.
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo|mysql -u root -p
Log back into MySQL and run the following.
mysql> stop slave;
mysql> start slave;
mysql> show slave status\G;
The error should be gone and the slave should be catching up to the master now. Problem solved.