mysql replication: replicate all but one table to different database on different server 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-&gt;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-&gt;database2"


Now mysql is starting, but table is not being replicated.
So I had some lunch and figured it out !

  replicate-do-table      = database2.table
  replicate-rewrite-db    = "database1-&gt;database2"