Mysql unknown command '\ "' Problem Solution

The original server environment uses windows, and then the database backed up by mysqldump cannot be imported into the database in linux. Import always appears:

Unknown command '"'

Therefore, if you replace all with ', the result still does not work and cannot be imported.

However, you can directly copy the database files. Copy the file before dumping it in dump. The results are the same.

Unknown command '"'

Depressing.

After export and import, it is found that mysql is installed by default using utf8 encoding, while mysql gbk database is installed on my local machine. In this way, a format error may occur when the backup file is restored.

Later, during dump, specify the character set mysqldump and add a parameter-default-character-set = gbk to import the backup file again. Everything went fine.

Mysqldump-u root-p-opt-allow-keywords-default-character-set = gbk databases>/PATH/XXX. SQL

Non-default character set. When importing and exporting data, specify the corresponding character set.