<div dir="ltr">Net buffer, probably not, max_packet, it'd be a good idea to tune it to your hard-drive+cache speed, which is typically about 120MB, unless your database is on NAS hardware, in which case it can be as high as 6.5GB.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Dec 4, 2014 at 7:20 PM, Keith Smith <span dir="ltr"><<a href="mailto:techlists@phpcoderusa.com" target="_blank">techlists@phpcoderusa.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
<br>
Amit,<br>
<br>
Your commands seem to have worked - thank you!!<br>
<br>
Do I need to set :<br>
1) global net_buffer_length=1000000;<br>
2) global max_allowed_packet=<u></u>10000000000000;<br>
<br>
to some lesser value?<br>
<br>
Any way it is detrimental to leave at these values as set?<br>
<br>
Thanks!!<br>
Keith<span class=""><br>
<br>
<br>
<br>
<br>
On 2014-12-04 17:22, Amit Nepal wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
You can just change the value of max packet for that session and<br>
import the file . This article might be helpful .<br>
<br>
<br>
<a href="http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/" target="_blank">http://www.amitnepal.com/<u></u>mysql-error-got-a-packet-<u></u>bigger-than-max_allowed_<u></u>packet-bytes/</a><br></span>
[2]<div><div class="h5"><br>
<br>
Thanks<br>
<br>
Amit K Nepal<br>
Chief Information Officer<br>
(RHCE, CCENT, C|EH, C|HFI, GIAC ISO 27000 Specialist)<br>
omNovia Technologies Inc. On 12/4/2014 3:47 PM, Bryan O'Neal wrote:<br>
<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
1) Max allowed packet is usually a replication not an important<br>
error. It can be described as a "I can not find the information it<br>
is looking for inside my search window" error.<br>
2) It is more often associated with corruption then a true packet<br>
size error. It also occasionally manifests when moving from 64 to 32<br>
bit. But it is possible that it is just a max packet problem<br>
3) using the client is more direct and less prone to error then<br>
using PHP my admin<br>
On Dec 4, 2014 2:34 PM, "Keith Smith" <<a href="mailto:techlists@phpcoderusa.com" target="_blank">techlists@phpcoderusa.com</a>><br>
wrote:<br>
<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
Hi,<br>
<br>
I'm trying to import a file into MySql on CentOS 6.6 and mysql<br>
Server version: 5.1.73.<br>
<br>
Un compressed the file is 611,285,457b or about 610MB. This is<br>
a production server and I am concerned about setting PHP<br>
upload_max_filesize that large.<br>
<br>
I tried to import via the command line and that failed. Tried<br>
uploading as a gz via PhpMyAdmin... that failed also. And I<br>
surely do not want to increase the memory allotted to PHP...<br>
<br>
I tried this:<br>
<br>
mysql --max_allowed_packet=650M -u root -p database < data.sql<br>
<br>
And received this error : ERROR 1153 (08S01) at line 1370225:<br>
Got a packet bigger than 'max_allowed_packet' bytes<br>
<br>
Thanks in advance!! Any suggestions?<br>
<br>
Keith<br>
<br>
--<br>
Keith Smith<br>
------------------------------<u></u>---------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.<u></u>org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
</div></div><a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/<u></u>mailman/listinfo/plug-discuss</a> [1]<br>
</blockquote><span class="">
<br>
------------------------------<u></u>---------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.<u></u>org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
</span><a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/<u></u>mailman/listinfo/plug-discuss</a> [1]<br>
</blockquote>
<br>
<br>
<br>
Links:<br>
------<br>
[1] <a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/<u></u>mailman/listinfo/plug-discuss</a><br>
[2]<br>
<a href="http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/" target="_blank">http://www.amitnepal.com/<u></u>mysql-error-got-a-packet-<u></u>bigger-than-max_allowed_<u></u>packet-bytes/</a><span class=""><br>
<br>
------------------------------<u></u>---------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.<u></u>org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/<u></u>mailman/listinfo/plug-discuss</a><br>
</span></blockquote><div class="HOEnZb"><div class="h5">
<br>
-- <br>
Keith Smith<br>
------------------------------<u></u>---------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.<u></u>org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss" target="_blank">http://lists.phxlinux.org/<u></u>mailman/listinfo/plug-discuss</a></div></div></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature">Todd Millecam</div>
</div>