From: Daevid Vincent
Date: October 19 2010 10:49pm
Subject: mysql_tzinfo_to_sql tz_file rebuilds tables for each tzdata!
List-Archive: http://lists.mysql.com/mysql/223393
Message-Id: <4317992D2D184F19B2A23DB65B9F1B6B@mascorp.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html#c11545

Note that if you are trying to keep your own database of cities and their
timezones, you can NOT use the mysql.time_zone_name.Time_zone_id as your FK
because the key will change the next time you get a new "tzdata" update
(like from an "apt-get update") and re-run "mysql_tzinfo_to_sql tz_file".
You'll have to store the "Name" column instead otherwise you loose data
integrity.

That script wipes the tables and re-creates them! rather than doing an
UPDATE to existing records as you would reasonably expect.

*sigh*