Sorting out Mysql Error : ERROR 1118 (42000) at line 27: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

on

 First of all open the mysql configuration file.

  •     Open xampp control panel
  •     Select my.ini configuration file from the second row MySQL . . . . Config button


Now add the following code in the end of [mysqld] section or above line containing text "[mysqldump]"

innodb_strict_mode=0


  • Save the configuration file by simply pressing Ctrl+S key.
  • Restart the mysql server by first clicking stop button after that Start Button.
  • Now upload the file again.
Errors will get Vanished.
Thankyou!


Comments

Post a Comment