Articles in this section

See more

Can't import database: Index column size too large. The maximum column size is 767 bytes

Avatar
Pablo Alvarez
Updated
Plesk for Linux kb: technical

Applicable to:

  • Plesk for Linux

Symptoms

Importing a database fails with the following error:

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

Cause

There are insufficient InnoDB values configured in MariaDB.

Resolution

Increase the InnoDB values directly on the server files; steps vary by OS.

   
CentOS/RHEL-based
   

  1. Log in via SSH

  2. Edit /etc/my.cnf with the following

    innodb_default_row_format = dynamic
    innodb_large_prefix = 1

  3. Restart MariaDB to apply the changes

    # systemctl restart mariadb

   
Ubuntu/Debian
   

  1. Connect to the server via SSH

  2. Edit /etc/mysql/my.cnf with the following

    innodb_default_row_format = dynamic
    innodb_large_prefix = 1

  3. Restart MariaDB to apply the changes

    # systemctl restart mariadb

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles