List:General Discussion« Previous MessageNext Message »
From:Dzenan Causevic Date:February 28 2007 3:21pm
Subject:FW: Does MySQL require patch for Daylight Savings Time 2007 change
View as plain text  
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.
Thread
FW: Does MySQL require patch for Daylight Savings Time 2007 changeDzenan Causevic28 Feb
  • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJean-Sebastien Pilon28 Feb
    • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz28 Feb
      • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJean-Sebastien Pilon28 Feb
        • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz28 Feb
          • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJean-Sebastien Pilon28 Feb
            • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz28 Feb
RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz13 Mar