Re: MySQL Daylight Savings Time Patch - easy check

[Ryan Stille]

I am on 4.1.20-1.

Maybe your OS isn't patched?

Try this:  "SELECT @@global.time_zone;"

If you get back "SYSTEM", then MySQL is looking to the OS for timezone 
data.  And its only loaded when MySQL starts, so if you haven't 
restarted MySQL since you patched your OS, you need to do that.

-Ryan

Jerry Schwartz wrote:
> What version of MySQL are you using? I'm running 4.1.21, and that check
> doesn't work even after I've updated (I think) the time zone tables.
>
> I should probably eyeball the output of mysql_tzinfo_to_sql.
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: [phone]
>
>
>   
>> -----Original Message-----
>> From: Ryan Stille [mailto:ryan@stripped]
>> Sent: Saturday, February 24, 2007 4:28 PM
>> To: mysql@stripped
>> Subject: Re: MySQL Daylight Savings Time Patch - easy check
>>
>> Ryan Stille wrote:
>>     
>>> Paul DuBois wrote:
>>>       
>>>> At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
>>>>         
>>>>> Is there an easy way to test to see if MySQL already has
>>>>>           
>> the proper
>>     
>>>>> tables loaded?
>>>>>
>>>>> -Ryan
>>>>>           
>>>> Yes, reload them. :-)  After that, they're current! .......
>>>>
>>>>         
>> After digging around on the net for a while I found an easy
>> way to tell
>> if your MySQL installation is ready for the new daylight savings time.
>>
>> SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),
>> UNIX_TIMESTAMP('2007-03-11 03:00:00');
>>
>> This should return the same value, even though you are feeding it
>> different times, because this is when the 1 hr change occurs.
>>  I get the
>> correct result on both of my machines.  On one of them I've run the
>> suggested |mysql_tzinfo_to_sql command, on the other, the time zone
>> tables are completely empty!
>>
>> Any wisdom on these time zone tables - are they ever used, should I
>> populate them or not?
>>
>> -Ryan
>>
>> |
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>>     
>
>
>
>
>