mysql replication: replicate all but one table to different database on different server

Question

I got database1 on server1 and database2 on server2.

Now I need to replicate a single table from database1 to database2

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 ?

EDIT:

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.

Answer 1

So I had some lunch and figured it out !

  replicate-do-table      = database2.table
  replicate-rewrite-db    = "database1->database2"

Answer 2

replicate-ignore-table  = database1.%
replicate-do-table      = database1.table
replicate-rewrite-db    = "database1->database2"

due to what you configured and refer to MySQL docs, the mistake in your configuration is that, you are rewriting the db (which will done before any replication rule) 1->2, and then filtering replication on DB1.

check replication execution rules, flow chart.