From: Date: February 20 2007 11:33pm Subject: RE: MySQL Daylight Savings Time Patch List-Archive: http://lists.mysql.com/mysql/205112 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" ; format="flowed" 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: dpgirago@stripped [mailto:dpgirago@stripped] >>Sent: Friday, February 09, 2007 9:30 AM >>To: mysql@stripped >>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 startup. The time zone can be specified explicitly by setting the TZ >TZ environment variable setting, or by using the --timezone option to the >mysqld_safe server startup script. > >Assuming that the server host itself has had its operating system updated >to handle the new Daylight Saving Time rules, that should be all that's >necessary for MySQL to know the correct time. I should mention also: For those of you running 4.1.3 or later, to get your MySQL server to know about the new DST rules, you should make sure your OS is updated with the new zoneinfo files, and then reload those files into MySQL with mysql_tzinfo_to_sql. See: http://dev.mysql.com/doc/mysql/en/time-zone-support.html Particularly the Note in the middle of the page and the last few paragraphs. You may have previously loaded your system's zoneinfo files into MySQL, but when those zoneinfo files are updated, the changes do not automatically propagate to MySQL's time zone tables. You must reload the tables to update them. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com