Knowledge Base

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

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.

There are insufficient InnoDB values configured in MariaDB.

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

CentOS/RHEL-based

Ubuntu/Debian

Log in via SSH
Edit /etc/my.cnf with the following

innodb_default_row_format = dynamic
innodb_large_prefix = 1
Restart MariaDB to apply the changes

# systemctl restart mariadb

Connect to the server via SSH
Edit /etc/mysql/my.cnf with the following

innodb_default_row_format = dynamic
innodb_large_prefix = 1
Restart MariaDB to apply the changes

# systemctl restart mariadb