Restore large backup Mysql file failed solution sharing _mysql

Use the following method (manage MySQL with navicat). Set the values of the following parameters to normal, the following statements can also be executed on the MySQL console.

Copy Code code as follows:

Show variables like '%timeout% ';
Show variables like '%packet% ';
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=100m

PS: If it is on the server, remember to restore these several parameters to be transferred back, otherwise the performance will fall, the specific parameters of these functions, we look for it.