Mysql互为主从问题--日志同步数据不同步 - 数据库编程

]

查看relay-B日志状态，可以看到日志已经同步
[root@XKWB5705 var]# /usr/local/mysql/bin/mysqlbinlog XKWB5705-relay-bin.000005|tail -13
/usr/local/mysql/bin/mysqlbinlog: Character set '#28' is not a compiled character set and is not specified in the '/usr/local/mysql/share/mysql/charsets/Index.xml' file
#110926 14:01:51 server id 1 end_log_pos 838 Query thread_id=5 exec_time=0 error_code=0
SET TIMESTAMP=1317016911/*!*/;
create table From246(Name varchar(255),Sex varchar(255),Age int(10))
/*!*/;
# at 853
#110926 14:02:05 server id 1 end_log_pos 966 Query thread_id=5 exec_time=0 error_code=0
SET TIMESTAMP=1317016925/*!*/;
insert into From246 (Name,Sex,Age)values('Zhaoyj','Girl',24)
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

但是数据却没有插入到relay-B的数据库
 mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| lian |
+----------------+
1 row in set (0.00 sec)

当我删除master-A上的表时，relay-B日志也同步了
[root@XKWB5705 var]# tail -4 XKWB5705-relay-bin.000005
NS @stdtestdrop table A246 NT@stdtestdrop table aniya NSd@stdtestdrop table lian NV @stdtestdrop table From246

这是什么奇怪问题？？
------------------------------------------------------------------------------
问题排查：

首先在Master-A上用

show processlist; 查看下进程是否Sleep太多。发现很正常

show master status; 也正常

再跑到Slave上查看 show slave status; 也正常

当我手动从A导入B数据时，发现一个问题：
mysql> load table From246 from master;
ERROR 1115 (42000): Unknown character set: 'gbk'

怀疑：难道是因为字符串的问题导致AB主从复制失败？

Mysql互为主从问题--日志同步数据不同步(二)