SQL Error (2006): MySQL server has gone away

adyoi's profile image adyoi posted 5 years ago in General Permalink

i'm try to upload sql file with size 3MB rows 92100

my log

/ SQL Error (2006): MySQL server has gone away / / Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. / / Cannot close tab with running query. Please wait until query has finished. /

HeidiSQL windows 10 64bit

ansgar's profile image ansgar posted 5 years ago Permalink

Your max_allowed_packet variable is too low for that 3M. Increase it and reconnect before running the LOAD command:

SET @@global.max_allowed_packet = 100*1024*1024;

Please login to leave a reply, or register at first.