请教一个replication的错误解决方法
ybgba 2011-09-28 10:39:53 error信息:
110927 19:23:05 [ERROR] Slave SQL: Error 'Unknown database 'gr5on_pc_beta_c'' on query. Default database: 'gr5on_pc_beta_c'. Query: 'CREATE DEFINER=`gr5onpcbetac`@`%` EVENT IF NOT EXISTS `connectionstats_cleanup` ON SCHEDULE EVERY 1 HOUR STARTS NOW() ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
DELETE FROM `connectionstats` WHERE logoutdate < DATE_SUB(NOW(), INTERVAL 1 DAY);
END', Error_code: 1049
110927 19:23:05 [Warning] Slave: The user specified as a definer ('gr5onpcbetac'@'%') does not exist Error_code: 1449
110927 19:23:05 [Warning] Slave: Unknown database 'gr5on_pc_beta_c' Error_code: 1049
110927 19:23:05 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.002736' position 196055028
根据信息是说没有找到数据库。
但是我并不需要复制这个数据库,当然就没有咯。
下面是我的配置:
replicate-wild-do-table=GR5ON_PC_BETA_E.%
replicate-wild-do-table=GR5ON_PC_BETA_E_STATS.%
replicate-wild-do-table=GR5ON_PC_BETA_E_LOGS.%
我只需要GR5ON_PC_BETA_E数据库,不需要gr5on_pc_beta_c,为什么会跳出这样的错误报告。
请高手达人指教。跪谢。