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.