MySQL enforces encoding to export and import data

Mysql may have different codes installed on windows and linux. If garbled characters occur during data import and export from these two databases, therefore, we can add a forced encoding to import and export databases:

1. mysql-uuser-p -- default-character-set = utf8 DBname <data. SQL

Export data with utf8

2. mysqldump-uuser-p -- default-character-set = utf8 DBname> data. SQL

Export data in UTF-8 encoding

Note:

The user is a mysql user, the DBname is the database name, and the data. SQL is the exported data.