pt-online-schema-change utf8mb4 错误解决方法

  • A+
所属分类:MySQL

本文地址:http://www.bhlaab.com/mysql/pt-online-schema-change-utf8mb4-error-solution/
文章摘要:pt,具体做法贻臭万年种子,油腻免费申请全面提升。

Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
Cannot connect to MySQL: DBI connect('med_data;host=127.0.0.1;mysql_read_default_group=client','root',...) failed: Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/) at /usr/bin/pt-online-schema-change line 2281

更改/usr/share/mysql/charsets/Index.xml 内容,将

改为

不光光pt-online-schema-change工具会遇到这个问题,其它工具也会,也是这么解决的。

微信公众号
扫一扫关注运维生存时间公众号,获取最新技术文章~

发表评论