Mysql：5.7，workbench：5.7.34
我想导入sql dump文件，问题是：
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: latin1img：enter image description here .使用此 latin1 编码导入后，网站内容将更改为错误的编码格式。sample：
如何导入转储文件而不发出编码警告？
2条答案
按热度按时间htrmnn0y1#
多亏了我的前辈。我会修好的
导入过程：在workbench中，选择Server > Data Import > Import from Selt-Contained File。选择导出SQL转储文件。然后选择目标数据库名称。好了，就这样。
导入进程时出错：双击sql dump文件，工作台自动打开，出现Unknown Encoding Alert
cclgggtu2#
选择选项“utf8”。这对我很有效。