mysql主从同步设置通配符忽略的表没生效

Question

如图，已经忽略的jnbi.ods_%的表了，还是报jnbi.ods表不存在

Error 'Table 'jnbi.ods_kf_vw_baozhuang' doesn't exist' on query. Default database: 'jnbi'. Query: 'insert into   sys_data_collection(bfl,sfl,datasource,zq,tn,tjdate,st,et,bsl,fsl,flag,sxh)
select '客服数据' bfl,'报装信息' sfl,'客服系统' datasource,'每日' zq,'ods_kf_vw_baozhuang' tn, date_format(now(),'%Y-%m-%d') tjdate,now() st,now() et,count(1) bsl,null fsl,0 flag,2 sxh
from ods_kf_vw_baozhuang'

Answer 1

修改配置后有没有重新启动mysql服务，使配置生效呢？