RE: MySQL Daylight Savings Time Patch - easy check

[Jerry Schwartz]

Oops - I should have done /etc/init.d/mysql restart

Things are now working just fine. Thanks for the tip about restarting the
server!

UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11
03:00:00')

--------------------------------------+-------------------------------------
-

                           1173596400 |
1173596400

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]


> -----Original Message-----
> From: Ryan Stille [mailto:ryan@stripped]
> Sent: Wednesday, February 28, 2007 5:10 PM
> To: mysql@stripped
> 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 if you haven't
> restarted MySQL since you patched your OS, you need to do that.
>
> -Ryan
>
> Jerry Schwartz wrote:
> > 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: [phone]
> >
> >
> >
> >> -----Original Message-----
> >> From: Ryan Stille [mailto:ryan@stripped]
> >> Sent: Saturday, February 24, 2007 4:28 PM
> >> To: mysql@stripped
> >> 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/mysql?unsub=1
> >>
> >>
> >>
> >
> >
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>