Mysqldump SQL export garbled

Environment

MySQL 5.1 + command line tool

Problem

Garbled characters are displayed in the exported SQL statement of mysqldump.

Solution

Mysqldump-uroot -- default-character-set = utf8-p axt> kq. SQL

Summary

SQL garbled characters may indicate that the global encoding of the database is inconsistent with that of a database. You can add the encoding during export, and change it to utf8 or gbk.

Mysqldump-u username -- default-character-set = utf8-p Database Name> file path \ file name. SQL