Mysql主从备份指定库别名

问题：replicate-rewrite-db  不生效

 

解决方案：

尝试 注释掉 replicate-do-db ，不写 replicate-ignore-db，只写 replicate-rewrite-db，发现这样是好使的。

 

#replicate-do-db=mpm
#replicate-do-db=test

#replicate-ignore-db=mysql
#replicate-ignore-db=information_schema
#replicate-ignore-db=performance_schema
#replicate-ignore-db=sys

replicate-rewrite-db=mpm->mpmbak
replicate-rewrite-db=test->test