我将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故障解决。
Unicode
UTF-8 Unicode
utf-8
primary
compiled
binary
compiled
可是执行还是报错。重启mysql后也还报错。后来,我在mysqlbinlog前加上路径后就好了,( ˇˍˇ )