Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

what is the meaning of "Max Insert Size" in Backup Database

dediajimk's profile image dediajimk posted 3 weeks ago in General Permalink

Dear HeidiSQL Developer,

I need to know what is the meaning of "Max Insert Size" in then Backup Database? if i leave it as default (1.024 Kb) and meanwhile the size of my DB is 56 MB. Is it OK for me to get backup my DB with this choice?

ansgar's profile image ansgar posted 3 weeks ago Permalink

Yes, that's just the maxium size of chunks with extended INSERT statements, into which HeidiSQL divides the data. The size is important because if you send too large statements with lots of value sets:

INSERT INTO.. VALUES (...), (...), ...

... that may break the connection when you import it.

See also https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.