On Nov 27, Troy.Travis@stripped wrote:
> To whom it may concern,
> We are currently using Bugzilla and PHPBB, both of which are backed by the
> MySQL dB an a Linux server (CentOS).
> Could someone please tell me if MySQL is going to need a patch due to the
> new (2007) Daylight Saving Time U.S change.
> Thank you very much in advance.
> - Troy
The timezone tables are available for download from
And this page also contains a warning:
Attention! Please don't use this package if your system includes
zoneinfo files (e.g. Linux, FreeBSD, Sun Solaris), please generate the
mysql.time_zone* tables from those files using the mysql_tzinfo_to_sql
utility instead! (Otherwise you may cause a difference in datetime
handling between MySQL and other applications on your system.)
So, you shouldn't download the tables, but generate them on your CentOS
server. If it suppors new Daylight Saving Time U.S change - so will
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Kerpen, Germany