Troubleshooting Windows MySQL command line import backup file query when the problem is garbled

MySQL import garbled, usually encountered in the command line. The following is the case of the command line that solves the garbled problem:

Method One: Solve garbled problem by adding parameter –default-character-set = UTF8

Mysql-uroot-p Linuxsight < F:\linuxsight\db.sql --default-character-set=utf8     #只要保证数据库的库表字符集正确, Just use this parameter to log in.

Method Two:

1.mysql>use xz;2.mysql> Set Names Utf8;3.mysql>source Example.sql

Method Three:

Mysql-u root-p--default-character-set=utf8use Dbnamesource/root/newsdata.sql

Troubleshooting Windows MySQL command line import backup file query when the problem is garbled