An error occurred while importing the SQL file from the mysql database.

An error occurred while importing the SQL file from the mysql database.
Sqlyog has been reminding you of the following problems when importing data files:
There was an error while executing a query.
The query and the error message has been logged:
C: \ Users \ liang \ AppData \ Roaming \ SQLyog \ sqlyog. err.

Please click on "Open Error File..." to open the error file.

The solution is as follows:

Find my. ini in the installation path of mysql and modify the parameter configuration.

[Mysqld] Add the following: max_allowed_packet = 768 M parameter size customized

After modification, restart the mysql Service (net stop mysql is disabled, and net start mysql is started; or manually restart mysql on the computer> Manage> service)

Go to mysql to check whether the operation is successful
Show variables like '% max_allowed_packet % ';

Shown as follows:
Max_allowed_packet | 805306368 indicates that the modification is successful.