Okay but after I patch OS do I still need to load time zone tables with
following command:
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Is this still necessary?
_______________________________
Dzenan Causevic
Web Applications Developer
NaviSite, Inc.
315-453-2912 x5346 (Office)
315-278-7371 (Cell)
www.NaviSite.com
-----Original Message-----
From: J.R. Bullington [mailto:bullijr@stripped]
Sent: Wednesday, February 28, 2007 9:40 AM
To: mysql@stripped
Subject: re: Does MySQL require patch for Daylight Savings Time 2007
change
As far as I know, MySQL does not need a TZ patch (unless
you use specific/custom Time Zone information), but your OS does.
The best way to check is to run:
mysql> SHOW VARIABLES LIKE 'TIME_ZONE';
If it says SYSTEM, then you need only patch your OS. (Patching the OS is
[OT] for this list).
Here's the section from the manual in regards to 3.23 Time Zones.
http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
J.R.
----------------------------------------
From: "Causevic, Dzenan"
<dcausevic@stripped>
Sent: Wednesday, February 28, 2007 9:29 AM
To: mysql@stripped
Subject: Does MySQL require patch for Daylight Savings Time 2007 change
I am running Apache HTTP 1.3 with PHP 4.2.2 and MySQL 3.23.
Do I need to apply any kind of patches to my MySQL related to Daylight
Savings Time 2007 change?
_______________________________
Dzenan Causevic
Web Applications Developer
NaviSite, Inc.
315-453-2912 x5346 (Office)
315-278-7371 (Cell)
www.NaviSite.com
This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.
This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.
