Shulou(Shulou.com)06/02 Report--

1 window system, mysql data import exception

2 Analysis of the reasons, most of them are incorrect character set settings during import and export.

3 specify a specific character set on import

4 case list

Use mysqldump to back up a database, and when you use mysql to restore the backup, prompt Unknown command'\'. Analyze the reason and get the reason of the character set. Just add-- default-character-set=utf8 when importing. The code is as follows.

Mysqldump-udbuser-p database table > exp.sql

Mysql-udbuser-p-- default-character-set=utf8 database < exp.sql

5 expansion

Sometimes the character set needs to be set GBK

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.