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.

Zip compressed sql files are corrupt

dippes's profile image dippes posted 9 months ago in General Permalink

Hello

I wanted to export my databases (3.1Gig) as a zip file.

The size of the exported database is 259 MB.

Unfortunately, this cannot be unpacked because it is defective. (The archive is damaged.)

I have tried several packers.

What is the reason for this?

ansgar's profile image ansgar posted 9 months ago Permalink

If your export is larger than 4GB then a ZIP compression is currently broken, due to the 32 bit ZIP algorithm used. See issue #1461. I was not aware of that until recently, so I highly recommend not to use the compression at all. Better use a separate compressor.

dippes's profile image dippes posted 9 months ago Permalink

I have now exported my database without compression. When I read it into the editor, I get an error message. See attachment.

Is the export now unusable?

1 attachment(s):
  • Heidisql
ansgar's profile image ansgar posted 9 months ago Permalink

I suppose the error pops up immediately, without progress? I've heard of such cases when the file is somehow locked by another process, or if privileges aren't sufficient to read it.

liamswift's profile image liamswift posted 2 months ago Permalink

Has this been fixed? Can't find anything in the changelogs about it. I'm on 11.1 and just lost 2 hours of work time on a 25GB database dump for nothing.

ansgar's profile image ansgar posted 2 months ago Permalink

Yes, I upgraded the used compiler version as mentioned above, but after the 12.0 release. So to get the fix, you need the latest build, as there is no v12.1 release yet. Hoping to get it out soon.

I also verified that by creating a 7GB table and exported it to a zip file. I can open it in 7-Zip and extract it without issues. The extracted file seems fine - checked that with less and tail.

liamswift's profile image liamswift posted 2 months ago Permalink

Okay, superb! Sorry, I had missed the issue link in your earlier comment.

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.