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:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 9:40 AM To: mysql@lists.mysql.com 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" <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2007 9:29 AM To: mysql@lists.mysql.com 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
