Skip to content

Tweak the mysqld-ram script to fix MySQL "Row size too large" errors.

decentral1se requested to merge fix_mysql_row_size_too_large into develop

Created by: qris

While restoring a ruforum database dump from the staging server into a ramdisk, I got this error:

ERROR 1118 (42000) at line 1185: 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.

The changes described in the Stack Overflow post made it work for me:

http://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large/15585700#15585700

Merge request reports