RE: MySQL Daylight Savings Time Patch - easy check

2007-03-01 Thread Jerry Schwartz
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

RE: MySQL Daylight Savings Time Patch - easy check

2007-03-01 Thread Jerry Schwartz
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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-28 Thread Ryan Stille
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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-28 Thread Néstor
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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-28 Thread William R. Mussatto
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 &

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-28 Thread Ryan Stille
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

RE: MySQL Daylight Savings Time Patch - easy check

2007-02-28 Thread Jerry Schwartz
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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-25 Thread Terry Riley
- 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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-24 Thread Mike Blezien
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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-24 Thread Ryan Stille
117360 | 1173603600 | +---+---+ Thx's Mickalo - Original Message - From: "Ryan Stille" <[EMAIL PROTECTED]> To: Sent: Saturday, February 24, 2007 3:28 PM Subject: Re: MyS

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-24 Thread Mike Blezien
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

Re: MySQL Daylight Savings Time Patch - easy check

2007-02-24 Thread Ryan Stille
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

Re: MySQL Daylight Savings Time Patch

2007-02-23 Thread Ryan Stille
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

Re: MySQL Daylight Savings Time Patch

2007-02-23 Thread Ryan Stille
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

Re: MySQL Daylight Savings Time Patch

2007-02-21 Thread Bryan S. Katz
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&

Re: MySQL Daylight Savings Time Patch

2007-02-21 Thread Aaron Cannon
l Message - From: "Jerry Schwartz" <[EMAIL PROTECTED]> To: "'Paul DuBois'" <[EMAIL PROTECTED]>; "'Sun, Jennifer'" <[EMAIL PROTECTED]>; "'Dan Buettner'" <[EMAIL PROTECTED]>; "'Chris White'&

RE: MySQL Daylight Savings Time Patch

2007-02-21 Thread Jerry Schwartz
, 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

RE: MySQL Daylight Savings Time Patch

2007-02-21 Thread Jerry Schwartz
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

RE: MySQL Daylight Savings Time Patch

2007-02-21 Thread Jerry Schwartz
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

Re: MySQL Daylight Savings Time Patch

2007-02-20 Thread Bryan S. Katz
rence. Which means that they were never being used. Any ideas? - Original Message - From: "Bryan S. Katz" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 20, 2007 7:50 PM Subject: MySQL Daylight Savings Time Patch > Running 4.1.22, on windows 98, I'm having

MySQL Daylight Savings Time Patch

2007-02-20 Thread Bryan S. Katz
Running 4.1.22, on windows 98, I'm having trouble getting the time zone tables to actually work. I've loaded the tables as per: http://dev.mysql.com/downloads/timezones.html, and followed the diagnostics as per: http://lists.mysql.com/mysql/205115 . It appears that my results from said diagnostic

Re: MySQL Daylight Savings Time Patch

2007-02-20 Thread Paul DuBois
Friday, February 09, 2007 9:30 AM To: mysql@lists.mysql.com 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

Re: MySQL Daylight Savings Time Patch

2007-02-20 Thread Ryan Stille
. -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 for MySQL 4.0.x series? I've been getting scary emails from our sys and net admins

RE: MySQL Daylight Savings Time Patch

2007-02-20 Thread Paul DuBois
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

RE: MySQL Daylight Savings Time Patch

2007-02-20 Thread Paul DuBois
AM To: mysql@lists.mysql.com 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 syst

RE: MySQL Daylight Savings Time Patch

2007-02-20 Thread Paul DuBois
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 spec

RE: MySQL Daylight Savings Time Patch

2007-02-20 Thread Sun, Jennifer
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

Re: MySQL Daylight Savings Time Patch

2007-02-20 Thread Dan Buettner
7 9:30 AM > To: mysql@lists.mysql.com > 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 If you&#

Re: MySQL Daylight Savings Time Patch

2007-02-20 Thread Chris White
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

RE: MySQL Daylight Savings Time Patch

2007-02-20 Thread Sun, Jennifer
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

MySQL Daylight Savings Time Patch

2007-02-09 Thread dpgirago
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