Mysql 数据库表单独导出和导入教程

Mysql 数据库表单独导出：

mysqldump -h 192.168.2.103 -P 3306 -u zyy -p pinyin phome_ecms_zidian >zidian.sql

Enter password: ********

-- Warning: column statistics not supported by the server.

报错要添加 --column-statistics=0

mysqldump -h 192.168.2.103 -P 3306 -u zyy -p --column-statistics=0 pinyin phome_ecms_zidian >zidian.sql

Enter password: ********

Mysql 数据库表单独导入：（我的数据库端口设置为了 5506）

mysql -P 5506 -u root -p pinyin2026 < english.sql

Enter password: ********

mysql -P 5506 -u root -p pinyin2026 < phome_ecms_chengyu.sql

Enter password: ********

ERROR at line 103: Unknown command '\\'.

ERROR 1064 (42000) at line 88: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''鍔ㄨ瘝:聽genuflect' at line 1

导入遇到问题，没有办法正常导入，十分头疼！

解决办法 添加 字符集参数选项 --default-character-set=utf8

mysql -P 5506 --default-character-set=utf8 -u root -p pinyin2026 < phome_ecms_zidian.sql