Zip compressed sql files are corrupt

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?

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.

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?

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.

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.

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.

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