MySQL importing large SQL file data problems

If the SQL file is too large, there will be MySQL out of memory (Needed XXX bytes), or "MySQL server has gone away" issue; In addition, if the SQL file data is in Chinese, garbled characters will appear.

Fix the problem, modify the max_allowed_packet parameter, in the My.ini or my.cnf file, set the following:

max_allowed_packet=500m

Restart MySQL, login, set code to UTF8

mysql-uroot-p123456  --default-character-set=utf8

Import successfully using the source command:

Use Mydb;source E:data\new.sql

After success, you will be prompted with the following: