[BlueOnyx:01259] Re: MySQL time incorrect

[Colin Jack]

> -----Original Message-----
> From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-bounces at blueonyx.it] On
> Behalf Of Chris Gebhardt - VIRTBIZ Internet
> Sent: Tuesday, May 19, 2009 1:40 PM
> To: BlueOnyx General Mailing List
> Subject: [BlueOnyx:01255] Re: MySQL time incorrect
> 
> Colin Jack wrote:
> > On our BlueOnyx servers we are seeing a problem where the time on the server is
> correct (set on the GUI to GMT) but the result from MySQL when using the now()
> command gives 5 hours earlier - so EST. This obviously causes web site developers
> a problem on our servers.
> >
> > Anybody able to help?
> 
> MySQL should read off your system's timezone.  Did you change your
> timezone?   If so, then a restart of MySQL service should fix.
> 
> Otherwise, you might have to use mysql_tzinfo_to_sql
> 
> --


That was what I thought but restarting the service didn't make any difference. 
I will dig about a bit further.

Thanks

Colin