[Novalug] MySQL time does not match system time

Peter Larsen plarsen at famlarsen.homelinux.com
Tue Apr 6 14:42:32 EDT 2010


On Tue, 2010-04-06 at 14:15 -0400, Mike McFadden wrote:
> Hi All,
> 
> I have searched and searched the internet for a solution to this problem with no luck and I'm stuck. I am running SuSE 10 and I reset the time when we went to daylight time. It is correct now:

Looks like mySQL has it's own timezone database
(http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html).
Following a few entries it could be that your timezone database is out
of sync with reality and hence needs updating
(http://dev.mysql.com/tech-resources/articles/daylight-saving-time-changes.html).

There's a lot of information of what you should check/do on the first
link. I would start there.

-- 
Best Regards
  Peter Larsen

Wise words of the day:
* SynrG notes that the number of configuration questions to answer in sendmail
  is NON-TRIVIAL
	-- Seen on #Debian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
Url : http://calypso.tux.org/pipermail/novalug/attachments/20100406/d3f6db80/attachment.bin 


More information about the Novalug mailing list