创建并导入已有数据库，Character set ‘ ... ‘ is not a compiled character set and is not specified in the ‘...‘

原创已于 2023-10-10 17:05:20 修改 · 3.6k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL添加数据库

于 2019-11-26 19:16:15 首次发布

MySQL添加数据库专栏收录该内容

1 篇文章

订阅专栏

本文描述了在Win7环境下使用MySQL 5.7.21版本时，遇到的从.sql文件导入数据库时出现的字符集错误问题。通过更改路径中反斜杠为正斜杠，成功解决了问题。

问题描述：Character set ' ... ' is not a compiled character set and is not specified in the '...'

操作系统：Win7；

MySQL版本：mysql-5.7.21-winx64

问题产生情景：创建并导入已有数据库（ .sql）；

问题产生原因（猜测）：路径中的反斜杠符号（' \ '）被当成了转义符，如图1中的

（“ Unknown command ' \S '. ”）；

问题产生如图1：

尝试方法1：将路径的反斜杠改为双反斜杠（' \ ' --> ' \\ '）

结论：问题未解决，如图2；

尝试方法2：将路径的反斜杠改为斜杠（' \ ' --> ' / '）

结论：问题解决，如图3；

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

一直不聪明

关注关注

3
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

MySQL4 File ‘c:\mysql\share\charsets\?.conf’ not found (Errcode: 22)的解决方法

12-15

.conf’ not found (Errcode: 22) Character set ‘#33′ is not a compiled character set and is not specified in the ‘c:\mysql\share\charsets\Index’ file 查阅一番后基本可以确定原因为低版本的PHP和高版本...

mysqlbinlog: Character set '#45' is not a compiled character set and is not specified in the '/usr/s

雅冰石的专栏

03-29

2570

我将5.5的二进制日志文件导入到5.6中，然后使用mysqlbinlog查看时报错： mysqlbinlog -v /download/master1-bin.001025 --stop-position= 713922982 > /download/f.log mysqlbinlog: Character set '#45' is not a compiled character

参与评论您还未登录，请先登录后发表或查看评论

Character set 'utf-8' is not a compiled character set and is not specified

热门推荐

Vincent

12-04

1万+

我在terminal登入mysql时候，如报下面错误：Mysql提示说你要在/usr/share/mysql/charsets/Index.xml文件将缺失的编码集加入，但是我检查后发现在Index.xml文件中有我需要的编码集。这个链接给出答案对我有效Character set 'utf-8' is not a compiled character set and is not specified

mysqlbinlog: Character set ‘#255‘ is not a compiled character set and is not specified in the ‘/usr/

蛙爸爸的博客

07-02

552

解压后的目录参考：D:\Downloads\mysql-8.0.41-linux-glibc2.28-x86_64\mysql-8.0.41-linux-glibc2.28-x86_64\mysql-8.0.41-linux-glibc2.28-x86_64\bin。我使用的是 MySQL 8 和 mysqlbinlog 3.4 ，后者版本太低了，应该更换成新版本。找到bin目录下的mysqlbinlog文件，替换到linux指定目录。mysql版本和mysqlbinlog版本不匹配。

mysql: Character set ‘utf8‘ is not a compiled character set and is not specified in the ‘C:\Program

闲言

03-01

1万+

mysql: Character set 'utf8' is not a compiled character set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\Index.xml' file

character set 'utf8</pre>' is not a compiled character set and is not specified in the 'c:\program files\mysql\mysql server 8.0\share\charsets\index.xml' file

03-16

这个错误提示是说字符集 'utf8' 没有被编译进 MySQL 中，并且也没有在 'c:\program files\mysql\mysql server 8.\share\charsets\index.xml' 文件中被指定。

mysql: character set 'utf8</pre>' is not a compiled character set and is not specified in the 'c:\program files\mysql\mysql server 8.0\share\charsets\index.xml' file

03-16

这个错误提示是因为MySQL没有编译utf8字符集，并且在c:\program files\mysql\mysql server 8.\share\charsets\index.xml文件中也没有指定utf8字符集。解决方法是在MySQL配置文件中指定utf8字符集，或者安装MySQL时...

mysql: Character set 'utf8??' is not a compiled character set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 9.3\share\charsets\Index.xml' file ERROR 2019 (HY000): Can't initialize character set utf8?? (path: C:\Program Files\MySQL\MySQL Server 9.3\share\charsets\)

07-18

引用[1]提到错误信息为"Can't initialize character set utf8"，而引用[2]则提到"Can't initialize character set utf8mb4"，并指出问题可能出现在连接字符串的格式上。用户提供的错误信息是"ERROR 2019 (HY000):...

我在CMD中运行命令：mysql -u root -p 结果报错信息如下： mysql: Character set 'utf-8' is not a compiled character set and is not specified in the 'C:\Program File\MySQL\MySQL Server 8.0\share\charsets\Index.xml' file ERROR 2019 (HY000): Can't initialize character set utf-8(path: C:\Program File\MySQL\MySQL Server 8.0\share\charsets\) 请问这是怎么回事，应该怎么解决？

最新发布

07-22

我们遇到的问题是在连接MySQL时出现的字符集错误：`Character set 'utf-8' is not a compiled character set...`。根据引用[1][2][3][4]中的信息，这个错误通常是因为MySQL无法识别或找到指定的字符集'utf-8'（注意...

MySQL报错： Character set ‘utf8mb4‘ is not a compiled character set and is not specified in the ‘/usr/s...

weixin_30865427的博客

12-07

1189

由于日常程序使用了字符集utf8mb4，为了避免每次更新时，set names utf8mb4，就把配置文件改了，如下： [root@~]# vim /etc/my.cnf #my.cnf [client] port = 3306 socket = /home/mysql/mysql.sock default-c...

mysql登录时报错mysql: Character set ‘utf8；‘ is not a compiled character set and is not specified in the ‘

sy15140060721的博客

08-25

6317

MySQL Command Line Client打不开时报错或者cmd进入数据库报错错误提示为mysql: Character set 'utf8;' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file. 解决方法为找到my.ini文件我的文件位置为C:\Program Files (x86)\MySQL\MySQL Se...

在doc登陆mysql提示Character set 'utf-8' is not a compiled character set and is not specified

qq_32675899的博客

07-17

9972

参考https://www.cnblogs.com/ahacn/archive/2011/12/24/2300532.html 1，错误重现安装好mysql后进入doc，进入mysql安装目录，然后输入mysql -u root -p 提示以下错误 2，处理方法在mysql安装目录下找到my.int, 打开找到default-character-set=utf-8改成defa...

django-vue-admin 使用Mariadb 连接提示Character set ‘utf8‘ is not a compiled character set解决

mihaoyun.com的专栏

06-21

680

Character set 'utf8' is not a compiled character set解决

mysql设置了utf8mb4还是报错_mysql报错问题解决Character set 'utf8mb4' is not a compiled character set...

weixin_42519781的博客

02-02

2143

mysql: Character set ‘utf8mb4‘ is not a compiled character set and is not specified in the ‘/usr/share/mysql/charsets/Index.xml‘ file报错的解决方法1、由于日常程序使用了字符集utf8mb4，为了避免每次更新时，set names utf8mb4，就把配置文件改了，如...

Character set ‘utfmb4‘is not a compiled character set and is not specified......

qq_60806689的博客

01-24

856

mysql -uroot -p Character set 'utfmb4' is not a compiled.....

用innobackupex备份mysql提示 “utf8mb4 is not a compiled character set”?

疯狂的石头

04-13

757

在配置文件最下面加上如下： [xtrabackup] default-character-set = utf8 即可。

binlog mysql unicode_mysqlbinlog: Character set '#45' is not a compiled character set and is not spe...

weixin_35926197的博客

02-15

263

我将5.5的二进制日志文件导入到5.6中，然后使用mysqlbinlog查看时报错：mysqlbinlog -v /download/master1-bin.001025 --stop-position= 713922982 > /download/f.logmysqlbinlog: Character set '#45' is not a compiled character set an...

mysql: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/sha...

weixin_30677617的博客

08-29

220

mysql: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file 转载于:https://www.cnblogs.com/lehao/p/3945092.html