Mysql 备份还原数据 操作教程

mysql还原数据库 Error at line 73 : Unknown command '\'

C:\Users>cd..

C:\>cd "Program Files"

C:\Program Files>cd MySQL

C:\Program Files\MySQL>cd "MySQL Server 8.0"

C:\Program Files\MySQL\MySQL Server 8.0>cd bin

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump -u root -p ChengYu > C:\ChengYu.sql

Enter password: ********

C:\Program Files\MySQL\MySQL Server 8.0\bin>

mysql导入时出现“ERROR at line : Unknown command ‘\‘‘.“的解决办法

原因:因为导出时字符集的问题，解决方法如下：--default-character-set=utf8

mysql命令行执行：

mysql -u root -p --default-character-set=utf8 ChengYu < C:\ChengYu.sql

C:\Users\Administrator>cd..

C:\Users>cd.

C:\Users>cd..

C:\>cd "Program Files"

C:\Program Files>cd MySQL

C:\Program Files\MySQL>cd "MySQL Server 8.0"

C:\Program Files\MySQL\MySQL Server 8.0>cd bin

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump -u root -p ChengYu > C:\ChengYu.sql

Enter password: ********

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p --default-character-set=utf8 ChengYu < C:\ChengYu.sql

Enter password: ********

C:\Program Files\MySQL\MySQL Server 8.0\bin>