Solve the problem of garbled mysqldump export SQL

Environment

MySQL 5.1 + command line tools

Problem

mysqldump Export SQL appears garbled

Solve

Mysqldump-uroot--default-character-set=utf8-p axt > Kq.sql

Summarize

Garbled is most likely the database's global encoding and a database encoding inconsistent. You can add code at the time of export and can be modified to UTF8 or GBK.

Mysqldump–u username--default-character-set=utf8-p database name > file path \ filename. sql

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/