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 4 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 4 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 4 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 4 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.

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.