MySQL database import fails: ERROR 1118 (42000): Row size too large

Symptoms

Importing of MySQL dump file to subscription's database fails with the following error:

ERROR 1118 (42000) at line 432: 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. 
Traceback (most recent call last): 
File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module> 
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main 
restore(options, password) 
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore 
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode) 
Exception: program 'mysql' finished with non-zero exit code: 1

Cause

Insufficient innodb log values.

Resolution

• Edit /etc/my.cnf file and increase the values of the innodb_log_buffer_size and innodb_log_file_size under [mysqld] section, for instance:


  [mysqld]
  innodb_log_file_size = 500M
  innodb_log_buffer_size = 800M

• Restart mysql service:
  

  # service mysql restart

Refer to the following link for more information: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te/25373052#25373052