Plesk for Linux
kb: technical
Applicable to:
- Plesk for Linux
Symptoms
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.
Cause
Incorrect MySQL configuration - insufficient InnoDB values.
Resolution
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
Comments
0 comments
Please sign in to leave a comment.