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

Symptoms

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

  CONFIG_TEXT: 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

Internal InnoDB limitations: MySQL bug tracker, Bug #69336

Resolution

1. Connect to the server via SSH

2. Edit MySQL configuration file using vi:

   • On .rpm-based distributions (CentOS, RHEL, CloudLinux): /etc/my.cnf file

   • On .deb-based distributions (Debian, Ubuntu): /etc/mysql/my.cnf file

3. Add the following content under [mysqld] section:

   CONFIG_TEXT: internal_tmp_disk_storage_engine=MyISAM
   innodb_strict_mode = 0

4. Restart MySQL service:

   # service mysql restart

5. Log into Plesk and proceed with database importing

   Note: It is recommended to revert changes back after importing dump file by removing added lines from the configuration and restarting the MySQL server as per steps 2 and 4.