List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:October 19 2010 10:49pm
Subject:mysql_tzinfo_to_sql tz_file rebuilds tables for each tzdata!
View as plain text  
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*

Thread
mysql_tzinfo_to_sql tz_file rebuilds tables for each tzdata!Daevid Vincent20 Oct