Cannot import database dump in Plesk: Index column size too large. The maximum column size is 767 bytes

Updated April 05, 2023 04:06

Plesk for Linux kb: technical

Applicable to:

Cannot import database dump in Plesk > Domains > example.com > Databases > the Import button (under the database):

CONFIG_TEXT: Failed to create tmp table table_name. Index column size too large. The maximum column size is 767 bytes.

Incorrect MySQL configuration - insufficient InnoDB values.

CentOS/RHEL-based

Connect to the server via SSH
Edit the file /etc/my.cnf as follows:

CONFIG_TEXT: innodb_default_row_format = dynamic
innodb_large_prefix = 1
Restart MySQL server to apply changes:

# systemctl restart mysqld

Ubuntu/Debian

Connect to the server via SSH
Edit the file /etc/mysql/my.cnf as follows:

CONFIG_TEXT: innodb_default_row_format = dynamic
innodb_large_prefix = 1
Restart MySQL server to apply changes:

# systemctl restart mysql