MariaDB Index column size too large

ERROR 1709

While restoring the database we are receiving the following error

ERROR 1709 (HY000) at line 15: Index column size too large. The maximum column size is 767 bytes.

To resolve the issue login into the Mysql prompt and execute the following commands.

SET GLOBAL innodb_file_format=Barracuda;

SET GLOBAL innodb_file_per_table=on;

SET GLOBAL innodb_large_prefix=on;

Now try to restore the database it will work.

 

 

About Anant 386 Articles
Senior technical writer