MySQL Forums
Forum List  »  Data Recovery

Unable to Import Previously Exported Data Containing BLObs
Posted by: Michael John
Date: January 07, 2015 05:57AM

I have been using a MySQL database for some three months. Two of the tables contain BLObs. One contains only two per row; one quite small at around 1kB and a larger one approaching 2MB. The other contains 10 BLObs per row ranging from 500kB to ~12MB. The tables have been archived quite regularly without any apparent problem. However I now have to load the data onto a new MySQL install. All the tables including the one with the smaller BLObs loaded without issue. However the table with the larger BLObs only loaded two rows before encountering an error:-

ERROR 1118 (42000) at line 53: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

Operation failed with exitcode 1 16:19:54 Import of /home/mjh/Desktop/Dump20141112 has finished with 1 errors.

The problem I have is how do I load this table. I am unable to go back to the original hardware as the disk has been wiped!

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to Import Previously Exported Data Containing BLObs
2294
January 07, 2015 05:57AM


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.