我试图设置两个MariaDB数据库之间的复制,但我在phpMyAdmin中出现以下错误:
Error 'Character set '#610' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file'
我检查了mysqld --verbose --help并且都使用UTF-8作为默认字符集。
太长的评论。 检查所有其他字符集定义。
SHOW VARIABLES LIKE 'character_set%';
数据库:
SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA;
表:
SELECT TABLE_SCHEMA, TABLE_NAME, ENGINE, TABLE_COLLATION FROM TABLES LIMIT 1000;
列:
SELECT COLUMN_NAME, TABLE_NAME, CHARACTER_SET_NAME, COLLATION_NAME FROM information_schema.COLUMNS WHERE CHARACTER_SET_NAME IS NOT NULL LIMIT 1000;
我添加了一个限制语句,只显示前1000行。 适应例如: WHERE CHARACTER_SET_NAME = '#610'
显示所有可用的字符集:
SHOW CHARACTER SET;
希望有助于find问题。