I have one the same server (Linux) two databases: db1 and db2 and I want to replicate db1.table1 to db2.table1
I added the following lines to my.cnf and restarted mysql service
replicate-do-table = db2.table
replicate-rewrite-db = database1->database2
but it's not working. Are those commands correct ? Do I need to set permissions on both databases ?
mysql version: 5.5.25a
Thanks in advance