Symptoms
Cannot import database dump in Plesk > Domains > example.com > Databases > the Import button (under the database):
Failed to create tmp table table_name. Index column size too large. The maximum column size is 767 bytes.
Cause
Incorrect MySQL configuration - insufficient InnoDB values.
Resolution
CentOS/RHEL-based
-
Connect to the server via SSH
-
Edit the file
/etc/my.cnfas follows: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.cnfas follows:innodb_default_row_format = dynamic
innodb_large_prefix = 1 -
Restart MySQL server to apply changes:
# systemctl restart mysql
with