When doing database restore recently, I encountered the following problems

ERROR 1118 (42000) at line 79532: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRnt row format, BLOB prefix of 768 bytes is stored inline.

Solution:

Modify the mysql configuration file my.cnf:

innodb_file_format=Barracuda 
innodb_file_per_table=1 

Then restart mysql and execute on the target table:
Alter table <table_name> engine=innodb ROW_FORMAT=DYNAMIC; 

Finally re-import.

If it still doesn’t work, consider adjusting the parameters:

innodb_log_file_size = 256M try to increase this configuration

Read More:

• Mysql Script Error Code: 1136. Column count doesn’t match value count at row 1
• Solve ERROR 1136 (21S01) in Mysql: Column count doesn’t match value count at row 1
• [Solved] Mysql Error: [Err] 1136 – Column count doesn‘t match value count at row 1
• Error 1406 (22001) in MySQL: data too long for column (Fixed)
• Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
• Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
• MYSQL Index Key Length 1071 – Specified key was too long； max key length is 3072 bytes
• [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
• [Solved] sqoop Import Datas to mysql error: ERROR tool.ExportTool: Error during export: Export job failed
• [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
• ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7
• [Solved] EOS7.6 Error: Init DB failed [Specified key was too long; max key length is 767 bytes…
• ERROR 1261 (01000): Row 1 doesn‘t contain data for all columns
• (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
• MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
• ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
• [Solved] Django configures MySQL Error: NameError: name ”_MySQL ‘is not defined
• How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
• MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘