Troubleshooting of Chinese garbled characters in mysql import and export data _ MySQL

Troubleshooting of Chinese garbled characters in mysql import and export data bitsCN.com In linux

Linux uses utf8 encoding by default, while windows uses gbk encoding, so the above garbled characters may occur.

Solve the problem of garbled data during mysql import and export

The first thing to do is to determine the encoding format of the exported data. when using mysqldump, add -- default-character-set = utf8,

For example, the following code:
Mysqldump-uroot-p -- default-character-set = utf8 dbname tablename> bak. SQL


When importing data, use -- default-character-set = utf8:

Mysql-uroot-p -- default-character-set = utf8 dbname <bak. SQL

In this way, the unified encoding solves the garbled characters in mysql data migration.


I use windows as the data source for export and import the mysql database in the freebsd environment

Solution:

Export data

1. use mysql as the source for exporting databases on windows. View the system variables of the character encoding:


Mysql> show variables like '% char % ';
+ ――――――――