use your my.cnf file that should be in /etc and put the line<div><br></div><div>max_allowed_packet=20M<br><br></div><div>in [mysqld] section.</div><div><br></div><div><br></div><div>Then restart mysql</div><div><br></div><div>

<br></div><div><br></div><div><div class="gmail_quote">On Tue, Sep 15, 2009 at 2:55 PM, Marretta, Rosanna <span dir="ltr">&lt;<a href="mailto:Rosanna.Marretta@yrclogistics.com">Rosanna.Marretta@yrclogistics.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">



<div>
<div><span><font face="Verdana" size="2">Hi,</font></span></div>
<div><span><font face="Verdana" size="2"></font></span> </div>
<div><span><font face="Verdana" size="2">Can somebody 
please tell me how to adjust the max_allowed_packet setting please for MySQL, it 
is currently set to 0MB and I need to change it to 8MB</font></span></div>
<div><span><font face="Verdana" size="2"></font></span> </div>
<div><span><font face="Verdana" size="2">Thanks</font></span></div>
<div> </div><font color="#888888">
<div align="left">
<div><span><span><span><span><span style="font-size:10pt;font-family:Verdana">Rosanna 
</span></span></span></span></span></div></div></font></div>
<br>---------------------------------------------------------------------<br>
OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br>
<br>
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!<br>
<a href="http://www.otrs.com/en/support/enterprise-subscription/" target="_blank">http://www.otrs.com/en/support/enterprise-subscription/</a><br></blockquote></div><br></div>