Mysql is often used in the development process to export and import Chinese tables. This article will detail how to use it. If you need it, refer
1. Export data for utf8 first:
(1) Export all tables of the source database:
Copy codeThe Code is as follows:
Mysqldump-u root-p password -- socket = mysql. sock -- default-character-set = utf8 -- set-charset = utf8 -- hex-blob -- databases Database Name> utf8. SQL
(2) modify the SQL file and delete the database creation commands contained in the file header.
(3) log on to the target database
Mysql-uroot-p password -- default-character-set = utf8 -- socket = mysql. sock-
Note: You must specify the character set to log on. In addition, the specified character set must be consistent with the character set specified during export.
(4) Delete A database (if any)
Drop database name;
(5) Create a database, save it as utf8 storage format, and import
Copy codeThe Code is as follows:
Create database name charset = utf8;
Use Database Name;
Source utf8. SQL;
After this item is imported, Chinese tables may contain garbled characters. Therefore, use the following method to import a Chinese table.
Ii. Export and Import a Chinese table:
Copy codeThe Code is as follows:
# Export
Mysqldump-u root-p password -- socket = mysql. sock -- default-character-set = gbk -- set-charset = gbk -- hex-blob database name table name 1 Table name 2 ...... > Gbk. SQL
# Import (if the table already exists, it will be deleted before being imported. Therefore, you do not need to delete the existing table in advance)
Mysql-uroot-p password -- default-character-set = gbk -- socket = mysql. sock-A <EOF
Use Database Name;
Source gbk. SQL
EOF