Thank you Bryan O'Neal, Amit Nepal, and Todd Millecam!! I was able to import the data and the app is running!! On 2014-12-04 20:46, Todd Millecam wrote: > 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/ >> [1] >> [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 [2] [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 [2] [1] > > Links: > ------ > [1] http://lists.phxlinux.org/mailman/listinfo/plug-discuss [2] > [2] > > http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/ > [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 [2] > > -- > 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 [2] > > -- > > Todd Millecam > > Links: > ------ > [1] > http://www.amitnepal.com/mysql-error-got-a-packet-bigger-than-max_allowed_packet-bytes/ > [2] http://lists.phxlinux.org/mailman/listinfo/plug-discuss > > --------------------------------------------------- > 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