![ERROR 1709](https://www.ktchost.com/blog/wp-content/uploads/2022/10/ERROR-1709.png)
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.