How to Fix Row Size Too Large (> 8126) in Godaddy Shared Hosting

You’ll get this error once your form exceeded the 8126-byte limit sets from the InnoDB of Godaddy Shared Hosting, this happens if you have a lot of LONGTEXT, TEXT and large VARCHAR fields from your table. For some reason, increasing the memory for your InnoDB database in the server in shared hosting is quite impossible and it requires another way to fix this error.

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.

But if you have access to it and still gonna use InnoDB database, all you have to do is edit the following on my.conf of your MySQL database.


For Godaddy Shared Hosting

For people who have no access to MySQL configuration, you can change the type of your database into MyISAM and add the option row_format=Compressed.

To do this, you just have to alter the table with the following SQL command.


Execute the command and it’s all good. Your form can now send a large amount of data to your database.

1 Comment

  • Wayne
    Posted March 20, 2022 12:29 am -12Likes

    The only way I could succeed was to:
    1. Go to the offending table.
    2. Select “Operations”.
    3. Choose “MyISAM” under Storage Engine
    4. After saving, check to ensure the ROW_FORMAT at the bottom of the same page is set to “Dynamic”

Leave a Comment

trabzon escort yalova escort Samsun escort izmit escort nazilli escort