<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">That should be just set for that
session, and should be back to the default as far as I can tell. <br>
<br>
Thanks<br>
Amit<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 7:20 PM, Keith Smith wrote:<br>
</div>
<blockquote
cite="mid:b1973367fdbdac15f5a71a4ce64508a8@phpcoderusa.com"
type="cite">
<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=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
<br>
<br>
<br>
<br>
<br>
On 2014-12-04 17:22, Amit Nepal wrote:
<br>
<blockquote type="cite">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 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>
[2]
<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>
<blockquote type="cite">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 class="moz-txt-link-rfc2396E" href="mailto:techlists@phpcoderusa.com"><techlists@phpcoderusa.com></a>
<br>
wrote:
<br>
<br>
<blockquote type="cite">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>
---------------------------------------------------
<br>
PLUG-discuss mailing list - <a class="moz-txt-link-abbreviated" href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.org</a>
<br>
To subscribe, unsubscribe, or to change your mail settings:
<br>
<a class="moz-txt-link-freetext" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a> [1]
<br>
</blockquote>
<br>
---------------------------------------------------
<br>
PLUG-discuss mailing list - <a class="moz-txt-link-abbreviated" href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.org</a>
<br>
To subscribe, unsubscribe, or to change your mail settings:
<br>
<a class="moz-txt-link-freetext" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a> [1]
<br>
</blockquote>
<br>
<br>
<br>
Links:
<br>
------
<br>
[1] <a class="moz-txt-link-freetext" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a>
<br>
[2]
<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>
PLUG-discuss mailing list - <a class="moz-txt-link-abbreviated" href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.org</a>
<br>
To subscribe, unsubscribe, or to change your mail settings:
<br>
<a class="moz-txt-link-freetext" href="http://lists.phxlinux.org/mailman/listinfo/plug-discuss">http://lists.phxlinux.org/mailman/listinfo/plug-discuss</a>
<br>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>