<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">You can just change the value of max
packet for that session and import the file . This article might
be helpful .<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/">http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/</a><br>
<br>
<br>
Thanks<br>
<br>
<div class="moz-signature"><b>Amit K Nepal<br>
Chief Information Officer
<br>
(RHCE, CCENT, C|EH, C|HFI, GIAC ISO 27000 Specialist)<br>
omNovia Technologies Inc.
</b></div>
On 12/4/2014 3:47 PM, Bryan O'Neal wrote:<br>
</div>
<blockquote
cite="mid:CAORnPwdYThJwevht8OG4ALftafBwQw3fPYPyx1NGDO3o88Jgvw@mail.gmail.com"
type="cite">
<p dir="ltr">1) Max allowed packet is usually a replication not an
important error. It can be described as a "I can not find the
information it is looking for inside my search window" error.<br>
2) It is more often associated with corruption then a true
packet size error. It also occasionally manifests when moving
from 64 to 32 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
using PHP my admin</p>
<div class="gmail_quote">On Dec 4, 2014 2:34 PM, "Keith Smith"
<<a moz-do-not-send="true"
href="mailto:techlists@phpcoderusa.com">techlists@phpcoderusa.com</a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
Hi,<br>
<br>
I'm trying to import a file into MySql on CentOS 6.6 and mysql
Server version: 5.1.73.<br>
<br>
Un compressed the file is 611,285,457b or about 610MB. This
is a production server and I am concerned about setting PHP
upload_max_filesize that large.<br>
<br>
I tried to import via the command line and that failed. Tried
uploading as a gz via PhpMyAdmin... that failed also. And I
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:
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>
---------------------------------------------------<br>
PLUG-discuss mailing list - <a moz-do-not-send="true"
href="mailto:PLUG-discuss@lists.phxlinux.org"
target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a moz-do-not-send="true"
href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss"
target="_blank">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">---------------------------------------------------
PLUG-discuss mailing list - <a class="moz-txt-link-abbreviated" href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.org</a>
To subscribe, unsubscribe, or to change your mail settings:
<a class="moz-txt-link-freetext" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a></pre>
</blockquote>
<br>
</body>
</html>