MySQL server has gone execute large script files

Question

Please help me to get rid of this errors While i run some large number of mysql scripts at once i got this kind of errors

ERROR: 2006 MySQL server has gone away Error: 1153 Got a packet bigger than 'max_allowed_packet' bytes

How to get rid of this error, im using Navicat mysql and WAMP server?? In running scripts i choose continue on error so scripts still running with error msgs and values in Message log. Will this work and can i run the error values later??

Answer 1

try using these commands from mysql terminal

set global max_allowed_packet=1000000000; 
set global net_buffer_length=1000000;