I suggest you put your glasses on, then. Getting of that horse might help, too.
default-time-zone='*timezone*' > > If you have the > SUPER<http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_super>privilege, > 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 <bcantw...@firescope.com>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:bcantw...@firescope.com] > > > Sent: Friday, October 01, 2010 10:25 AM > > > To: mysql@lists.mysql.com > > > 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