Amit,
Your commands seem to have worked - thank you!!
Do I need to set :
1) global net_buffer_length=1000000;
2) global max_allowed_packet=10000000000000;
to some lesser value?
Any way it is detrimental to leave at these values as set?
Thanks!!
Keith
On 2014-12-04 17:22, Amit Nepal wrote:
> You can just change the value of max packet for that session and
> import the file . This article might be helpful .
>
>
> http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
> [2]
>
> Thanks
>
> Amit K Nepal
> Chief Information Officer
> (RHCE, CCENT, C|EH, C|HFI, GIAC ISO 27000 Specialist)
> omNovia Technologies Inc. On 12/4/2014 3:47 PM, Bryan O'Neal wrote:
>
>> 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.
>> 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
>> 3) using the client is more direct and less prone to error then
>> using PHP my admin
>> On Dec 4, 2014 2:34 PM, "Keith Smith" <techlists@phpcoderusa.com>
>> wrote:
>>
>>> Hi,
>>>
>>> I'm trying to import a file into MySql on CentOS 6.6 and mysql
>>> Server version: 5.1.73.
>>>
>>> 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.
>>>
>>> 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...
>>>
>>> I tried this:
>>>
>>> mysql --max_allowed_packet=650M -u root -p database < data.sql
>>>
>>> And received this error : ERROR 1153 (08S01) at line 1370225:
>>> Got a packet bigger than 'max_allowed_packet' bytes
>>>
>>> Thanks in advance!! Any suggestions?
>>>
>>> Keith
>>>
>>> --
>>> Keith Smith
>>> ---------------------------------------------------
>>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>>> To subscribe, unsubscribe, or to change your mail settings:
>>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1]
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss [1]
>
>
>
> Links:
> ------
> [1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss
> [2]
> http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
--
Keith Smith
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss 
(text/plain)