PhpMyAdmin import error

Question

I am trying to import a database using phpMyAdmin. The file is compressed in .zip.

Every time I try to import, I get this error:

Error in ZIP archive: compressed size is not equal to the value in the header information.

I tried to export the file again and used different compression applications, but always get the same error.

How can i fix this?

Answer 1

I don’t know what the reason is, but you can fix it by renaming the file in .gz for example database.sql.zip to database.sql.gz or if your program supports it, you can compress it into a .gz file in the first place - this will also fix the problem

Answer 2

- (StartLogic).

Guitar MacUpdate .sql gzip. .

Answer 3

AFAIK, this error is caused by a damaged ZIP at boot time.

You can try and extract the zip and load the actual sql.