MySql max_allowed_packet

Todd Millecam tyggna at gmail.com
Thu Dec 4 15:10:56 MST 2014


I would try also increasing your net buffer for the command, via a set
net_buffer_length=1000000;
Try disabling foreign key checks too, if you know the data.sql file is
clean and doesn't violate any foreign key constraints.
You might get a bit more granularity if you don't try to do it all in one
command and use the interactive shell instead:
mysql -u root -p database
> set global max_allowed_packet=10000000000;
ect . . .
> source data.sql;


-- 
Todd Millecam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20141204/96108df1/attachment.html>


More information about the PLUG-discuss mailing list