-
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 isn't patched?
Try this: SELECT @@global.time_zone;
If you get back SYSTEM
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 SYSTEM, then MySQL is looking to the OS for
timezone
data. And its only loaded when MySQL starts, so
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 Stille wrote:
Paul DuBois wrote:
At 4:40 PM
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 Patch - easy check
Ryan Stille wrote:
Paul DuBois
To: mysql@lists.mysql.com
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
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 Patch - easy check
Ryan Stille
24, 2007 4:28 PM
To: mysql@lists.mysql.com
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
- 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 has the proper
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
|
+---+---+
Thx's
Mickalo
- Original Message -
From: Ryan Stille [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
|
+---+---+
Thx's
Mickalo
- Original Message - From: Ryan Stille [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, February 24, 2007 3:28 PM
Subject: Re: MySQL Daylight Savings Time Patch - easy check
Ryan Stille wrote:
Paul
PROTECTED]
To: mysql@lists.mysql.com
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 of my
servers
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
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
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:
Any answers for the question below
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.
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
shifts are correct in the future and incorrect
Schwartz [EMAIL PROTECTED]
To: 'Paul DuBois' [EMAIL PROTECTED]; 'Sun, Jennifer'
[EMAIL PROTECTED]; 'Dan Buettner' [EMAIL PROTECTED];
'Chris White' [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 21, 2007 8:45 AM
Subject: RE: MySQL Daylight Savings Time Patch
I just ran
Yes they are; and 22 = 3
- Original Message -
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Bryan S. Katz' [EMAIL PROTECTED];
mysql@lists.mysql.com
Sent: Wednesday, February 21, 2007 10:30 AM
Subject: RE: MySQL Daylight Savings Time Patch
Aren't the time zone tables new in 4.1.3
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
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
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 using NTP then what's the problem? Sync to one of the ntp
pools, boom your clocks are updated, MySQL uses system
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
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
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 system
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
.
-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 about
-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 Daylight Savings
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
. Which means that they
were never being used.
Any ideas?
- Original Message -
From: Bryan S. Katz [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, February 20, 2007 7:50 PM
Subject: MySQL Daylight Savings Time Patch
Running 4.1.22, on windows 98, I'm having trouble getting
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
31 matches
Mail list logo