mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126

Permalink
Hi All,

I a getting mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126

Can anyone please help me on this?

Thanks
Anil

View Replies:
Myq replied on at Permalink Reply 1 Attachment
Myq
One way to get around this is to change the "row_format" for the problematic table to "dynamic". Even if the database is set to use dynamic by default for tables, ensure that the table throwing the error is set to dynamic.