Articles in this section

See more

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

Avatar
Leonid Gukhman
Updated
Follow

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

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.

Cause

MySQL bug which returns the error even if row size is smaller than 8126 columns: MySQL bug tracker, Bug #69336

Resolution

For Linux

  1. Connect to the server via SSH

  2. Open the 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

For Windows

  1. Connect to the server via RDP

  2. Open the MySQL configuration file %plesk_dir%Databases\MySQL\my.ini

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

    CONFIG_TEXT: innodb_strict_mode = 0

  4. Restart MySQL service using Plesk Services Monitor.

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

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles