How to limit command size in backup/restore

[expired user #9600]'s profile image [expired user #9600] posted 8 years ago in General Permalink

I think is anything about Security Bank software. When restoring backup in HeidiSQL, over network, network communication freeze, need reboot machine.

My application creates a backup too. It was freezing when restoring by HeidiSQL. Solve this reducing line length in backup.

I would like try to do the same in HeidiSQL, because I use HeidiSQL backup too.

(from/to sql file)

At momment I am using a limit of 500.000 characters per line in my application. Limmit in server is default: 4.194.304

ansgar's profile image ansgar posted 8 years ago Permalink

HeidiSQL does not care about the length of lines, neither when creating sql files nor when reading/restoring them. If HeidiSQL "freezes", then it's just busy with executing queries, probably over a slow connection. Do not reboot your machine, but wait until it has finished. There is no need to reduce the width of lines.

[expired user #9600]'s profile image [expired user #9600] posted 8 years ago Permalink

My fault. HeidiSQL have this option. HeidiSQL default is 1000kb, reduce to 500kb and no more freeze.

Note: Freeze is ALL tcp/ip communication, not only HeidiSQL. After reboot ok, and using 500kb block ok.

ansgar's profile image ansgar posted 8 years ago Permalink

You mean the "Max INSERT size". Do not mix that with some "Max line length" setting. However, glad that helped you.

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