MySQL Forums
Forum List  »  Backup

problem with dumping table with longblob
Posted by: Sim Boh
Date: June 06, 2013 04:28AM


I'm trying to dump database with several tables using mysqldump. Backup file is created whitout any errors and I can restore it also. Everyting looks well except the table which contains column with datatype LONGBLOB. After restoring row number and data lenght is not the same as in original database(accoriding to MySQL Administrator), software that is using it says the data is corrupted. The whole database is rather small (less than 500kb). I've been trying to use --hex-blob parameters however it didn't help. I would be grateful for any hints, suggestions.(I'm using MySQL 5.1.68 on windows)

Best regards,

Options: ReplyQuote

Written By
problem with dumping table with longblob
June 06, 2013 04:28AM

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.