MySQL Forums
Forum List  »  General

Re: Problem with timezone
Posted by: Peter Brawley
Date: November 22, 2016 02:35PM

Oh, you'd suggested MySQL was returning an AMT date, but you were talking about freebsd.

You say "this is production server and I can't restart the server." Well, from time to time, all servers must restart or repair themselves, so all apps have to be able to deal with access interruptions.

So I'd do four things ...

1 Add the desired timezone setting to my.cnf

2 Add setting the desired session timezone setting to the MySQL connection module

3 Teach the app how to handle access interruptions

4 Restart mysql at a time of minimal connection count.

Options: ReplyQuote


Subject
Written By
Posted
November 17, 2016 05:29AM
November 17, 2016 10:49AM
November 21, 2016 12:45AM
November 21, 2016 01:59PM
November 22, 2016 02:57AM
Re: Problem with timezone
November 22, 2016 02:35PM
November 23, 2016 12:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.