MySQL Forums
Forum List  »  Archive Storage Engine

.zip data corrupted when exported by select dumpfile
Posted by: Ricardo Faria
Date: December 02, 2009 06:42PM

I have an InnoDB table storing a compress file (.zip) into two columns: Data (longblob) and Filename (text). When a export the file via select into dumpfile... I am not able to extract the file at command line. All the compress programs alert the file is corrupted, but I am able to extract them inside the windows. I read somewhere something related to the drop of a last zero of the binary file.
Is anyone have an idea how to solve such a problem?

Options: ReplyQuote

Written By
.zip data corrupted when exported by select dumpfile
December 02, 2009 06:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.