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

Dmitry Bystrov

10 months ago

Symptoms

Importing a MySQL dump file to a subscription's database in Subscriptions > example.com > Databases > Import 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.

MySQL InnoDB requires database records to fit in the B-tree leaf page. See MySQL bug tracker, Bug #69336 for more details.

Connect to the server via SSH
Back up the MySQL configuration file /etc/my.cnf:

# cp /etc/my.cnf{,.bak}
Add the following lines to the file in step 2. under [mysqld] section:

default_storage_engine=MyISAM
innodb_strict_mode = 0
Restart MySQL service:

# service mysql restart
Import the MySQL database
Restore backed up MySQL configuration file

# mv /etc/my.cnf.bak /etc/my.cnf --force
Restart MySQL service :

# service mysql restart

Connect to the server via SSH
Create a backup of the MySQL configuration file /etc/mysql/my.cnf:

# cp /etc/mysql/my.cnf{,.bak}
Add the following lines to the file in step 2. under [mysqld] section:

default_storage_engine=MyISAM
innodb_strict_mode = 0
Restart MySQL service:

# service mysql restart
Import the MySQL database
Restore backed up MySQL configuration file

# mv /etc/mysql/my.cnf.bak /etc/mysql/my.cnf --force
Restart MySQL service :

# service mysql restart

Connect to the server via RDP
Copy the file %plesk_dir%DatabasesMySQLmy.ini to %plesk_dir%DatabasesMySQLmy.ini_bak
Add the following lines to the file in step 2. under [mysqld] section:

innodb_strict_mode = 0
Restart MySQL service using Plesk Services Monitor
Import the MySQL database
Restore file %plesk_dir%DatabasesMySQLmy.ini_bak to %plesk_dir%DatabasesMySQLmy.ini
Restart MySQL service using Plesk Services Monitor

0 Shares