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

Created:

2017-06-12 18:30:36 UTC

Modified:

2017-08-16 17:27:58 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk for Linux

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

Have more questions? Submit a request
Please sign in to leave a comment.