Mysql : 5.7,工作台: 5.7.34
我想导入sql转储文件,问题是:
Unknown File Encoding
The file '/xxx.sql' is not UTF-8 encoded.
Please select the encoding of the file and press OK for Workbench to convert and open it.
Note that as Workbench works with UTF-8 text, if you save back to the original file,
its contents will be replaced with the converted data.
WARNING: If your file contains binary data, it may become corrupted.
Click "Run SQL Script..." to execute the file without opening for editing.
Character Set Encoding Name: latin1在这里输入图像描述.使用此latin1编码导入后,站点内容将更改为错误的编码格式。样本:ă,ăƒ™ăƒłăƒˆăƒťźšč°ăƒŹăƒăƒźă。
如何导入转储文件而不发出编码警报?
发布于 2022-02-08 04:02:10
多亏了我的大四学生。我把它修好。
导入过程:在工作台中,服务器>数据导入>自包含文件导入.选择导出sql转储文件。然后选择“目标数据库名称”。好的,仅此而已。
导入过程错误:双击sql转储文件,工作台将自动打开,未知编码警报将发生.
https://stackoverflow.com/questions/71013904
复制相似问题