Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-02-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report