The solution of unknown command'\ 'when MYSQL uses source command to import database

This article mainly explains the "MYSQL using source commands to import database unknown command 'solution", the article explained the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "MYSQL using source commands to import database unknown command'\ 'solution" it!

MYSQL uses source command to import unknown command'\ 'solution

In the past, it was possible to import, but why not today? So I feel very depressed.

But I didn't think much about it, so I did something else. After a while, I suddenly remembered.

This should be a coding problem. Some time ago, the coding was changed to utf-8, because the project done by others was deployed.

Www.2cto.com

If you don't change it to utf-8, you can't insert the photos inside, and then the code backed up by the database at that time is gbk.

So I opened the my.ini in the directory and changed the default-character-set entry in the file to gbk.

Then restart the mysql service. When importing, it will be OK.

Thank you for your reading, the above is the content of "MYSQL using source command to import database unknown command'\ 'solution". After the study of this article, I believe you have a deeper understanding of the problem that MYSQL uses source command to import database unknown command'\ 'solution, and the specific use still needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!