To do this on Linux, use MySQL's utility script, "mysql_tzinfo_to_sql".
Example usage:
mysql_tzinfo_to_sql /usr/share/zoneinfoThis returns a sql script to run to setup the timezone information. The following will setup the timezone information directly:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysqlNow you can view your timestamps in local timezone:
SELECT CONVERT_TZ('2010-01-02 00:00:00', 'UTC', 'America/Chicago' );