I'm trying to update my timezone database, on CentOS, the database located at /usr/share/zoneinfo.
I downloaded the time zone data from IANA here: http://www.iana.org/time-zones
I tried editing the 'make' file and executing that, but got several errors so I'm not sure that was the right thing to do. I also tried just replacing my zoneinfo folder with this new data, and got the error that my timezone database was corrupt.
Am I missing something obvious, or am I missing instructions somewhere on how to do this? Would someone tell me how to install this?
(I'm trying to do this because mysql is giving me errors like this: 'error: SET time_zone = 'US/Pacific' Unknown or incorrect time zone: 'US/Pacific').
Thank you! 🙂
Best Answer
Don't update the zoneinfo database manually. Just install the updates which are already provided for you by EL/CentOS in the
tzdata
package:Also note that MySQL keeps its own internal time zone tables, separate from the system timezone database. To update MySQL's internal time zone tables, run the
mysql_tzinfo_to_sql
script which came with MySQL.