# MySQL: error 1118 (42000) row size too large

errorsmyisamMySQLmysqldump

1. storage_engine = MyISAM

2. table_type = MyISAM

3. version = 5.1.25-rc

database_name.sql dump size is 3.3G:

mysqldump -u user -p database_name > database_name.sql


When I try to restore the database (trying to restore on MySQL 5.1.25-rc and on 5.7.17):

mysql -u user -p database_name < database_name.sql


…an error:

ERROR 1118 (42000) at line 7192: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

If not, then let's see the CREATE TABLE that is leading to the problem.
Or, maybe, a CHARACTER SET default changed.
Show us the first part of the dump and the CREATE TABLE just before the naughty table.