phpMyAdmin Import Error

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

Every time I try the import I get开发者_StackOverflow中文版 this error:

Error in ZIP archive: Compressed size is not equal with the value in header information.

I've tried exporting the file again and and used different applications to compress it but I always get the same error.

How can I fix this?

i dont know whats the reason for it, but you can fix this by rename the file to .gz e.g. database.sql.zip to database.sql.gz or if your program supports it, you can compress it to a .gz file in the first hand - this will also fix the problem

I had this same problem with a host provider (StartLogic).

I downloaded Guitar from MacUpdate and used the app to compress my .sql file into gzip format. Didn't have any problems importing my database after that.

AFAIK, this error is caused due to a corruption of the ZIP during upload.

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