From: Johan De Meersman Date: October 3 2010 8:23am Subject: Re: Any way to change timezone WITHOUT mysqld restart? List-Archive: http://lists.mysql.com/mysql/223221 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0022152d6e5985d8470491b223dc --0022152d6e5985d8470491b223dc Content-Type: text/plain; charset=ISO-8859-1 I suggest you put your glasses on, then. Getting of that horse might help, too. default-time-zone='*timezone*' > > If you have the SUPERprivilege, you can set the global server time zone value at runtime with > this statement: > On Sat, Oct 2, 2010 at 2:18 PM, Bryan Cantwell wrote: > As a matter of fact I did, the real question is : Did you even read my > email? I said WITHOUT a restart... > The manual states that a restart of the mysqld is required. The reason > for the post to such a list is because on many occasions, user have > suggestions on some workaround for things that do work in spite of what > the manual says. > > On Fri, 2010-10-01 at 15:42 -0700, Daevid Vincent wrote: > > > Did you even look at the manual? > > > > http://lmgtfy.com/?q=mysql+set+timezone > > > > First link. > > > > > > > -----Original Message----- > > > From: Bryan Cantwell [mailto:bcantwell@stripped] > > > Sent: Friday, October 01, 2010 10:25 AM > > > To: mysql@stripped > > > Subject: Any way to change timezone WITHOUT mysqld restart? > > > > > > Any way to change timezone WITHOUT mysqld restart? > > > It would be a lifesaver if there were some way for me not to have to > > > restart because if mysql restarts then I have to go through a lot of > > > other issues with my other apps. > > > > > > > > > > > > > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0022152d6e5985d8470491b223dc--