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 reload the tables anyway? Thanks.
Note Loading the time zone information is not necessarily a one-time operation because the information changes occasionally. For example, the rules for Daylight Saving Time in the United States, Mexico, and parts of Canada changed in 2007. When such changes occur, applications that use the old rules become out of date and you may find it necessary to reload the time zone tables to keep the information used by your MySQL server current. See the notes at the end of this section. -----Original Message----- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 5:03 PM 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 "the epoch". The epoch, in the case of most UNIX-based OSes, is midnight January 1, 1970. I think Windows is the same. The original Mac OS was 1/1/1904, for example. It's up to the operating system to apply rules that determine that X number of seconds (as reported by the clock hardware) since the epoch translates to some human time, based on local settings for time zone and with any daylight savings time rules for that time zone applied. My understanding is that MySQL needs no patch, but your underlying OS most likely does. I know there have been patches issued for Solaris 2.x, 9 and 10, Windows XP, and Mac OS X 10.4, and almost certainly others. HTH, Dan On 2/20/07, Chris White <[EMAIL PROTECTED]> wrote: > > 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 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 time and yay. > I'm fairly sure you could sync 500 server this way. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
