Articles in this section

See more

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

Avatar
Mikhail Shport
Updated
Follow
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

  1. Connect to the server via SSH

  2. Edit the file /etc/my.cnf as follows:

    CONFIG_TEXT: innodb_default_row_format = dynamic
    innodb_large_prefix = 1

  3. Restart MySQL server to apply changes:

    # systemctl restart mysqld

Ubuntu/Debian

  1. Connect to the server via SSH

  2. Edit the file /etc/mysql/my.cnf as follows:

    CONFIG_TEXT: innodb_default_row_format = dynamic
    innodb_large_prefix = 1

  3. Restart MySQL server to apply changes:

    # systemctl restart mysql

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles