Solution to the failure of restoring the mysql file of large backup _ MySQL

Solution for restoring a large backup mysql File: bitsCN.com

During the maintenance of the company's CRM today, a large mysql database was restored and the recovery failed.

Use the following method (navicat is used for mysql management). set the values of the following parameters and the following statements can be executed on the mysql console.

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 = 100 M

PS: If it is on the server, remember to call these parameters back after recovery, or the performance will degrade. for specific parameter functions, please find them by yourself.

BitsCN.com