Applicable to:
- Plesk
Symptoms
-
Importing MySQL dump file to subscription's database in Plesk > Subscription > example.com > Databases > Import 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.
-
InnoDB is set as default storage engine in MySQL:
# plesk db "show engines" | egrep DEFAULT
| InnoDB | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES |C:\> plesk db "show engines" | findstr DEFAULT
| InnoDB | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES |
Cause
MySQL InnoDB requires the record to fit in the B-tree leaf page. See MySQL bug tracker, Bug #69336 for more details.
Resolution
Warning: It is recommended to revert the changes after importing dump file by removing the added lines from the configuration and restarting the MySQL server.
-
Connect to the server via SSH.
-
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
-
-
Add the following content under [mysqld] section:
CONFIG_TEXT: default_storage_engine=MyISAM
innodb_strict_mode = 0 -
Restart MySQL service:
# service mysql restart
-
Import the MySQL database
-
Once the MySQL database is imported, it is recommended to revert the changes.
-
Connect to the server via RDP.
-
Open the MySQL configuration file
%plesk_dir%Databases\MySQL\my.ini
. -
Add the following line under [mysqld] section:
CONFIG_TEXT: innodb_strict_mode = 0
-
Restart MySQL service using Plesk Services Monitor.
-
Import the MySQL database
-
Once the MySQL database is imported, it is recommended to revert the changes.
Note: in case the issue still persists, open the database dump with any text editor and replace all occurences of ENGINE=InnoDB
to ENGINE=MyISAM
.
Comments
1 comment
Hi!
Thanks for posting this solution. It helped me with installation of Zabbix on Raspberry Pi4 running MySQL / MariaDB. Latest Raspbian / Debian 10 buster.
Please sign in to leave a comment.