mysql_tzinfo_to_sql tz_file rebuilds tables for each tzdata!

http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.htm l#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*


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org