[BlueOnyx:09081] Re: mysql timestamp

[Charles Bowman]

If you login to the GUI , them go to: system Settings -> Time
Is the date & time correct?
Is the value for "Time Zone" correct?
Do you have an "NTP Server Address" defined and is it in your time zone?

mySQL should take the time from the "system_time_zone" system variable.

So, unless you start mySQL manually setting the time on start-up, it should
use SYSTEM var.
In mySQL execute the following query: SELECT @@global.time_zone,
@@session.time_zone;
This should result in: "SYSTEM" | "SYSTEM"
Showing your time as coming from the system; so just update your timezone
in system Settings -> Time.

Cheers,
C

On 21 November 2011 09:03, Steffan <general at ziggo.nl> wrote:

> Hello,
>
> I have a server where mysql timestamp is 6 hour behind the server time
> in the gui I change the zone safed it
> changed it back saved it but did didns solve the problem
>
> any idees
>
> greats
>
> Steffan
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20111121/4c858e6a/attachment.html>