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

来源：互联网发布：美国农业数据美元指数编辑：程序博客网时间：2024/06/06 09:33

我将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 set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file

按照网上说的“添加utf8mb4字符集到Index.xml ”

直接复制utf8的配置，改为utf8mb4后，添加到/app/soft/mysql/share/charsets/Index.xml故障解决。
<charset name="utf8mb4">
<family>Unicode</family>
<description>UTF-8 Unicode</description>
<alias>utf-8</alias>
<collation name="utf8_general_ci" id="33">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_bin" id="83">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
</charset>

可是执行还是报错。重启mysql后也还报错。后来，我在mysqlbinlog前加上路径后就好了，( ˇˍˇ )

--本篇文章参考自：http://www.th7.cn/db/mysql/201412/84402.shtml

0 0