SQL file import and export garbled _ MySQL

Solve bitsCN.com

SQL file import and export garbled solution

Today, an SQL execution file is exported from windows and then poured into unbutn. The result is garbled,

Solution

When exporting the mysql SQL execution file, specify the encoding format:

The code is as follows:

Mysqldump-uroot-p -- default-character-set = utf8 mo (dbname)> E: // xxxx. SQL

The import is OK.

Run the following command:

The code is as follows:

Mysql-u root-p -- default-character-set = utf8 use dbname source/root/newsdata. SQL

BitsCN.com