From: Date: February 20 2007 11:40pm
Subject: Re: MySQL Daylight Savings Time Patch
List-Archive: http://lists.mysql.com/mysql/205114
Message-Id: <45DB78D7.2050101@cfwebtools.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Is there an easy way to test to see if MySQL already has the proper 
tables loaded?

-Ryan

Paul DuBois wrote:
> At 4:17 PM -0600 2/20/07, Paul DuBois wrote:
>> At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote:
>>> Any answers for the question below ?
>>>
>>> Is there a DST patch for MySql 4.0.20?   Thanks.
>>>
>>> -----Original Message-----
>>> From: dpgirago@stripped [mailto:dpgirago@stripped]
>>> Sent: Friday, February 09, 2007 9:30 AM
>>> To: mysql@stripped
>>> Subject: MySQL Daylight Savings Time Patch
>>>
>>> Is there a DST patch for MySQL 4.0.x series?
>>>
>>> I've been getting scary emails from our sys and net admins about
>>> impending
>>> doom.
>>>
>>> Thanks,
>>>
>>> David
>>
>> Before MySQL 4.1.3, the server gets its time zone from the operating 
>> system
>> at startup.  The time zone can be specified explicitly by setting the TZ
>> TZ environment variable setting, or by using the --timezone option to 
>> the
>> mysqld_safe server startup script.
>>
>> Assuming that the server host itself has had its operating system 
>> updated
>> to handle the new Daylight Saving Time rules, that should be all that's
>> necessary for MySQL to know the correct time.
>
> I should mention also:
>
> For those of you running 4.1.3 or later, to get your MySQL server to
> know about the new DST rules, you should make sure your OS is updated
> with the new zoneinfo files, and then reload those files into MySQL
> with mysql_tzinfo_to_sql.  See:
>
> http://dev.mysql.com/doc/mysql/en/time-zone-support.html
>
> Particularly the Note in the middle of the page and the last few 
> paragraphs.
>
> You may have previously loaded your system's zoneinfo files into MySQL,
> but when those zoneinfo files are updated, the changes do not 
> automatically
> propagate to MySQL's time zone tables.  You must reload the tables to 
> update
> them.
>