I kept getting this annoying error on my test instances of MySQL when running pt-query-upgrade using logs I pulled from production:
DBD::mysql::st execute failed: Unknown or incorrect time zone: 'America/Los_Angeles' [for Statement "SET time_zone = 'America/Los_Angeles'"]
SET time_zone = 'America/Los_Angeles'
The solution was to install time zones onto the testing instance like this:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Some of the timezones didn't install but it did install for America/Lost Angelese which made my error go away.
No comments:
Post a Comment