Mysql export and import a Chinese Table

Mysql export and import Chinese Table 1. Export for utf8 first: (1) Export all tables of the source database: mysqldump-u root-p password -- socket = mysql. sock -- default-character-set = utf8 -- set-charset = utf8 -- hex-blob -- databases Database Name> utf8. SQL www.2cto.com (2) modify the SQL file, command for deleting the database created in the file header (3) log on to the mysql-uroot-p password -- default-character-set = utf8 -- socket = mysql. sock-A note: You must specify the character set to log on. The specified character set must be consistent with the character set specified during export. (4) drop database name (if any; (5) create a database, save it as utf8 storage format, and import it to create d Atabase database name charset = utf8; use Database Name; source utf8. SQL; Chinese tables may contain garbled characters after the import. Therefore, use the following method to import a Chinese table. Ii. Export and import the Chinese Table: # 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