MySQL Bugs: #62682: Import Errors

Bug #62682	Import Errors
Submitted:	11 Oct 2011 15:46	Modified:	11 Oct 2011 16:43
Reporter:	Vance Bankhead	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Data Types	Severity:	S2 (Serious)
Version:	5.0.92	OS:	Linux (phpMyAdmin 3.4.5)
Assigned to:		CPU Architecture:	Any

Description:
Export To: Open Document Spreadsheet
Import From: Open Document Spreadsheet
Results in this error below.
You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.
This has been going for at least two weeks, when is this going to be fixed.
Every since you dropped using Excel Spreadsheets then end of September this problem has been there.

How to repeat:
Use a WordPress database is a good test. Using the *_postmeta table export
the data, preferably it has has several rows (100+). Export to Open Document Spreadsheet, empty the table and try the import won't work. Saving the data to a csv file from the Calc Spreadsheet & try to import it. It truncates the data and errors out. This is why I selected a WP table like the postmeta it will not import from a csv file. THIS ALWAYS WORK WHEN YOU HAD EXCEL!. The OpenOffice Calc program is just as good as Excel, BUT it won't import without an error.
"You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration."

What exactly you had tried to do, and with what software? Why do you think your problem has anything to do with any bugs in MySQL server 5.0.92?

It seems that you have nothing to do with phpMyAdmin. I was told to post
the issue here. You can close this then.

you attempted to load file with unsupported compression (application/zip). either support for it is not implemented or disabled

Attachment: tbl_assettbl_asset.ods (application/vnd.oasis.opendocument.spreadsheet, text), 43.21 KiB.