MySQL import and export, and error logging

Go to the MySQL bin directory, if the MySQL bin adds environment variables.

Export, without specifying the encoding, defaults to: UTF8MB4. ：

Mysql-u root-h 127.0.0.1-p 3307-p--default-character-set=utf8mb4 Dxoa < G:/bak.sql.

Import, without specifying the encoding, the default is Utf-8:

mysql-u root-h 127.0.0.1-p 3307- P--default-character-set=utf8mb4 Dxoa < G:/bak.sql

Issue record:

1, if the export import of the MySQL service did not start, then the error: Can ' t connect to localhost (10043) similar to this, StackOverflow on the said may also be port unspecified, [-p].

2, import times: ERROR at line 4635:unknown command ' \ n '. is because the export is inconsistent with the imported encoding.

MySQL import and export, and error logging