How to solve an error when importing mysql big data in Navicat? navicatmysql

How to solve an error when importing mysql big data in Navicat? navicatmysql

Navicat's own data is everywhere and cannot be imported during import.
Finally, use the MySQL command to import data.

Command Used

UseShortcut \ u
SourceShortcut \.

You can use help to query shortcuts.

Mysql> \ u dataname mysql> \. d: \ mysql \ dataname. SQL

Problems encountered during import and Solutions
Chinese garbled characters during import

Solution:

UTF8 encoding is used when Navicat is used for export. MySQL uses its own default encoding method for import, and garbled characters are generated in Chinese.
Query by command

Mysql> show variables like '% char % ';

The encoding shown in the query is gbk.
And then all

Mysql> set character_set_results = utf8; mysql> set ...... (all classes are modified to utf8)

Execute import again. OK! The code is normal and imported successfully.