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

dediajimk's profile image dediajimk posted 4 years 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 4 years 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.