mysql unknown command ' \ ' problem solving method

Unknown command ' "'

So the ' replace all ' result or not, the import is not.

However, it is possible to copy the database files directly to the past. Copy the past after the dump came out. The result is still the same effect

Unknown command ' "'

Extremely depressed.

After many are exported import found that the original default installed MySQL is UTF8 encoding, and I installed the MySQL GBK database. As a result, the backup files may be incorrectly formatted when they are restored.

Later, in dump, specify the character set mysqldump add a parameter:-DEFAULT-CHARACTER-SET=GBK, import the backup file again, everything goes well.

Mysqldump-u ROOT-P–OPT–ALLOW-KEYWORDS–DEFAULT-CHARACTER-SET=GBK Databases >/path/xxx.sql

Non-default character set, specifying appropriate character set in import Export note