esday, February 28, 2007 5:10 PM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL Daylight Savings Time Patch - easy check
>
> I am on 4.1.20-1.
>
> Maybe your OS isn't patched?
>
> Try this: "SELECT @@global.time_zone;"
>
> If you get back "SYSTE
796 / FAX: 860.674.8341
> -Original Message-
> From: Ryan Stille [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 28, 2007 5:10 PM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL Daylight Savings Time Patch - easy check
>
> I am on 4.1.20-1.
>
> Maybe your OS i
artz
>> Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>>
>>
>>
>>> -Original Message-
>>> From: Ryan Stille [mailto:[EMAIL PROTECTED]
>>> Sent: S
0.674.8796 / FAX: 860.674.8341
>>
>>
>>
>>> -Original Message-
>>> From: Ryan Stille [mailto:[EMAIL PROTECTED]
>>> Sent: Saturday, February 24, 2007 4:28 PM
>>> To: mysql@lists.mysql.com
>>> Subject: Re: MySQL Daylight Savings
n Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>>
>>
>>
>>> -Original Message-
>>> From: Ryan Stille [mailto:[EMAIL PROTECTED]
>>> Sent: Saturday, February 24, 2007 4:28 PM
>>> To: mysql@lists.mysql.com
&
Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 24, 2007 4:28 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL Daylight Savings Time Patc
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Ryan Stille [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 24, 2007 4:28 PM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL Daylight Savings Time Patch - easy check
>
> Ryan
- Original Message -
> *From:* Ryan Stille <[EMAIL PROTECTED]>
> *To:* mysql@lists.mysql.com
> *Date:* Sat, 24 Feb 2007 15:28:25 -0600
>
> 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
Stille" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 24, 2007 4:07 PM
Subject: Re: MySQL Daylight Savings Time Patch - easy check
I'm not exactly sure what you should do, hence my earlier question about the
empty time zone tables. I get the same (correct) result on both
117360 |
1173603600 |
+---+---+
Thx's
Mickalo
- Original Message - From: "Ryan Stille" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 24, 2007 3:28 PM
Subject: Re: MyS
000 |1173603600
|
+---+---+
Thx's
Mickalo
- Original Message -
From: "Ryan Stille" <[EMAIL PROTECTED]>
To:
Sent: Saturday, February 24, 2007 3:28 PM
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 e
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! ...
My timezone tables appear to be empty. At least the tim
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! ...
My timezone tables appear to be empty. At least the time_zone_name and
tim
Yes they are; and 22 >= 3
- Original Message -
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'Bryan S. Katz'" <[EMAIL PROTECTED]>;
Sent: Wednesday, February 21, 2007 10:30 AM
Subject: RE: MySQL Daylight Savings Time Patch
> Aren&
l Message -
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'Paul DuBois'" <[EMAIL PROTECTED]>; "'Sun, Jennifer'"
<[EMAIL PROTECTED]>; "'Dan Buettner'" <[EMAIL PROTECTED]>;
"'Chris White'&
, 2007 9:03 PM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL Daylight Savings Time Patch
>
> Same exact issue on v5.0.27.
>
> I installed another windows patch, that did nothing, but then
> changed my
> system clock to march 12th, and then back to present day. Now the DST
I just ran mysql_tzinfo_to_sql on a CentOS (Linux) system, and it complained
about the various Riyadh time zones:
Warning: Unable to load '/usr/share/zoneinfo/right/Mideast/Riyadh87' as time
zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/right/Mideast/Riyadh88' as time
zone. Skipp
Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 20, 2007 5:17 PM
> To: Sun, Jennifer; [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: RE: MySQL Daylight Savings Time Patch
>
> At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote:
> >An
Same exact issue on v5.0.27.
I installed another windows patch, that did nothing, but then changed my
system clock to march 12th, and then back to present day. Now the DST
shifts are correct in the future and incorrect in the past. I've destroyed
the timezone tables, and they made no difference.
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!
If you really want a non-reload test, you can do something like this
(Credits: This example comes from Pet
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.
At 5:08 PM -0500 2/20/07, Sun, Jennifer wrote:
Thanks. Below is the notes from the version 5 manual, does that mean
after I patch my OS, I may need to reload the timezone tables ? How I
can determine that I have to reload the timezone tables, not might need?
Or will it hurt anything if I just rel
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 9:30 AM
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 9:30 AM
To: mysql@lists.mysql.com
Subject: MySQL Dayl
To: Chris White
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Daylight Savings Time Patch
NTP won't solve this problem for you.
NTP, as well as most computer clocks, know nothing about daylight
savings
time, or about time zones. What they know is how many seconds have
elapsed
since
NTP won't solve this problem for you.
NTP, as well as most computer clocks, know nothing about daylight savings
time, or about time zones. What they know is how many seconds have elapsed
since "the epoch". The epoch, in the case of most UNIX-based OSes, is
midnight January 1, 1970. I think Win
Sun, Jennifer wrote:
Any answers for the question below ?
Is there a DST patch for MySql 4.0.20? Thanks.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 9:30 AM
To: mysql@lists.mysql.com
Subject: MySQL Daylight Savings Time Patc
Any answers for the question below ?
Is there a DST patch for MySql 4.0.20? Thanks.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 9:30 AM
To: mysql@lists.mysql.com
Subject: MySQL Daylight Savings Time Patch
Is there a DST patch
29 matches
Mail list logo
