Hi!
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
http://dev.mysql.com/downloads/timezones.html
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
MySQL.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Kerpen, Germany
<___/ www.mysql.com
