MySQL Source command import data garbled problem

Today from Windows to export a SQL execution file, and then poured into the unbutn, the results appear garbled, toss 7-8 minutes,
Resolution method
When you export the MySQL SQL execution file, specify the encoding format:

The code is as follows	Copy Code
Mysqldump-uroot-p--default-character-set=utf8 Mo (dbname) > E://xxxx.sql

It's OK when you import it.

Perform the following

The code is as follows	Copy Code
Mysql-u root-p--default-character-set=utf8 Use dbname Source/root/newsdata.sql

MySQL Set encoding command

The code is as follows	Copy Code
SET character_set_client = UTF8; SET character_set_connection = UTF8; SET character_set_database = UTF8; SET Character_set_results = utf8;/* here to pay attention to very useful * * SET character_set_server = UTF8; SET collation_connection = Utf8_bin; SET collation_database = Utf8_bin; SET collation_server = Utf8_bin;

Configure default encoding in My.ini

code is as follows	copy code
Default-charact Er-set=utf8