Replication in same server within different databases. Mysql 5.6 What I have :


a windows machine with one instance of MySQL 5.6 Server.
two database named test and test2. 
Test database has a table called activity with columns id and class


What I need :


replication of test.activity table to test2 database with a condition that Test.activity.class = 'B'.


I know how to replicate with in different server. But not for same server within different database.I have checked this link , but it does not give enough information.
Cause it's on the same server, why don't you use a trigger for this? 

If you just wanna replicate data you can add a triger on update or on insert or both whatever you need. This way you can use your condition easily. Master/Slave replication would be better for different servers.

You can look here for mysql Trigger examples.
And here is a sample for your case.