I think that's only true if the server is using the default system time zone. In addition, you can set a per-connection time zone and use time zone sensitive functions such as CONVERT_TZ(). All of these mean that MySQL needs to be aware of time zone definitions. There could also be trouble if you are using replication across time zones, I suspect.
There are explicit instructions for building time zone tables in section 5.9.8 of the manual. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----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: > >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 > > 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. > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
