Now I need to replicate a single table from
Now I thought that this would work:
replicate-ignore-table = % replicate-do-table = table replicate-rewrite-db = "database1->database2"
but this does not seem to work as mysql does not accept
% symbol with
replicate-ignore-table directive. any ideas ?
I have tried :
replicate-ignore-table = database1.% replicate-do-table = database1.table replicate-rewrite-db = "database1->database2"
Now mysql is starting, but table is not being replicated.