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. On Thu, Dec 4, 2014 at 7:20 PM, Keith Smith wrote: > > > 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" >>> 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 > -- Todd Millecam