I'm still not having any luck. I did
shell> /etc.init.d/mysql reload
my @@global.time_zone is still SYSTEM, and yet I still get
UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11
03:00:00')
--------------------------------------+-------------------------------------
-
1173596400 |
1173600000
shell> date -d "mar 11 02:00"
Sun Mar 11 03:00:00 EDT 2007
so my OS does have the right settings.
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: Wednesday, February 28, 2007 5:10 PM
> To: mysql@lists.mysql.com
> 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: 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
