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: latin1
img: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”。这对我很有效。