Solution to the failure of restoring the mysql File

The solution for restoring the large backup mysql file failed. Today, when maintaining the company's CRM, a large mysql database was restored and the recovery failed. use the following method (navicat is used for mysql management )., after the values of the following parameters are set, the following statements can be executed on the mysql console. show variables like '% timeout %'; show variables like '% packet %'; www.2cto.com set global max_allowed_packet = 99328000; set global wait_timeout = 2880000; set global interactive_timeout = 2880000; -- wait_timeout = 2880000 -- interactive_timeout = 2880000 -- max_allowed_packet = 100 M PS, let's look for the specific parameter functions.