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