MySQL - Row size too large - BLOB prefix of 768 bytes is stored inline

gistfile1.sql

-- Error Message: 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.
--
-- our table name that has this issue is XYZ
--
SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=ON;
ALTER TABLE XYZ ROW_FORMAT=COMPRESSED;

Thank you man for your help

Thank you man, you saved my day. You are awsome

thanks ...it works fine.....

If mysql version is below 5.7, you can only fix the error from the above method
The above problem will be fixed automatically by mysql version 5.7 and above
I hope this helps someone

I recently tried similar, 62 columns with Varchar 255 in InnoDB, I resolved it by using reasionable length for each column instead of the 255.

I used the largest value from all rows and 2x the size and compared if that exceeds the 255 so I would use TEXT, rether than varchar 255. the trick did it. :)

hope it will help someone, rather then altering default settings.