Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

SQL Error (2006): MySQL server has gone away

adyoi's profile image adyoi posted 2 months ago in General

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 10.2.0.5599 windows 10 64bit

ansgar's profile image ansgar posted 2 months ago

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.