Shulou(Shulou.com)05/31 Report--

This article mainly introduces "MySQL database export SQL garbled how to solve", in the daily operation, I believe that many people in the MySQL database export SQL garbled how to solve the problem, Xiaobian consulted all kinds of information, sorted out a simple and useful method of operation, hope to answer the "MySQL database export SQL garbled how to solve" doubt! Next, please follow the editor to study!

Garbled resolution occurred in MySQL export SQL

Environment: NavicatforMysql8.2 + MySQL Sever 5.1

Problem: garbled code in MySQL database export SQL

Resolve:

Method 1:

Change the encoding of the database to UTF-8.

Database-> right-click-> Database Properties-> character set-> Select UTF-8- > OK.

Www.2cto.com

Method 2 (use this method if there is still garbled code after using method 1):

Use the command to export the database.

Win + R-> cmd- > change to Mysql's bin directory (or the bin directory added in the system's environment variable)-> enter the following command-> then enter the password.

[sql]

Mysqldump-u root-p zxct > c:\ users\ wentasy\ desktop\ zxct.sql

Www.2cto.com

Note:

Root: user name

Zxct: database name

Zxct.sql: export database sql file name

If you do not specify a directory, it is saved in the bin directory of mysql.

At this point, on the "MySQL database export SQL garbled how to solve" on the end of the study, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.