1

I've a php script which changes the database engine from MyISAM to InnoDB. The script worked perfect until today i stumbled over a database where it's not working.

The error is:

Error while executing SQL: 42000 1118 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. Last statement was: ALTER TABLE Table ENGINE=InnoDB;

Are there any other solutions to that than switching innodb file format to Barracuda and using compressed row formats?

Pramod
  • 2,828
  • 6
  • 31
  • 40
catweazle
  • 153
  • 1
  • 1
  • 6
  • Try this answer: [MySQL: Error Code: 1118 Row size too large (> 8126)][1] [1]: http://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te – Alex Tartan May 07 '15 at 14:06

0 Answers0