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.
>
