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

This article mainly introduces how to solve the problem of Mysql import garbled code, the article introduces in great detail, has a certain reference value, interested friends must read it!

Solve the problem of garbled code in Mysql import

Method 1: solve the garbled code problem by adding the parameter-default-character-set = utf8

C:\ Users\ Administrator > mysql-uroot-p yktgl

Use gl

2.mysql > set names utf8

3.mysql > source example.sql

Mysql-u root-p-- default-character-set=utf8

Use dbname

Source / root/newsdata.sql

Method 3: paste the code in the sql file directly

1. Open the SQLyog client software

two。 Navigate to the SQL editor and use notepad to open the SQL file you just exported

3. Copy all the SQL statements in the file into the SQL editor and execute the SQL code

2. Export data

Mysqldump-u root-p-- default-character-set=utf8 gl > gl.sql

Define Encoding Import

Mysql-u root-p-- default-character-set=utf8-f discuss_chi

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.