Solution to the error when importing MySQL big data in Navicat

The data that Navicat has exported cannot be imported.
Finally, choose to use MySQL command import to complete the data import

Use the command

use shortcut_
source shortcut\.

The shortcuts can be found through help

mysql>_dataname 
mysql>\. d:\mysql\dataname.sql

Problems encountered during import and solutions Chinese characters are garbled during import

Solution:

When exporting with Navicat, UTF8 encoding is used. When importing, MySQL uses its own default encoding method to import. Chinese characters are garbled. Use the command to query

mysql>show variables like '%char%';

The query shows that the encoding is gbk
Then all the found

mysql>set character_set_results=utf8; 
mysql>set .....(similar to all changed to utf8)

Execute the import again, OK! The encoding is normal and imported successfully.