What version of MySQL are you using? I'm running 4.1.21, and that check doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball the output of mysql_tzinfo_to_sql. Regards, Jerry 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 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 that, they're current! ....... > >> > > After digging around on the net for a while I found an easy > way to tell > if your MySQL installation is ready for the new daylight savings time. > > SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), > UNIX_TIMESTAMP('2007-03-11 03:00:00'); > > This should return the same value, even though you are feeding it > different times, because this is when the 1 hr change occurs. > I get the > correct result on both of my machines. On one of them I've run the > suggested |mysql_tzinfo_to_sql command, on the other, the time zone > tables are completely empty! > > Any wisdom on these time zone tables - are they ever used, should I > populate them or not? > > -Ryan > > | > > > -- > 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]