MySql max_allowed_packet

Keith Smith techlists at phpcoderusa.com
Thu Dec 4 14:34:48 MST 2014


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


More information about the PLUG-discuss mailing list