Timeline for mysql replication: replicate all but one table to different database on different server
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 25, 2012 at 21:16 | vote | accept | Katafalkas | ||
| Nov 24, 2012 at 3:02 | comment | added | RolandoMySQLDBA |
I am glad to figured this one out yourself. I have something to share with you: replicate-ignore-table and replicate-do-table cannot be mixed any more than scotch and blood pressure meds. ( See my ServerFault post serverfault.com/a/271588/69271 under possibility #6 along with dev.mysql.com/doc/refman/5.1/en/… ) You get a +1 for removing replicate-ignore-table = database1.% to solve it.
|
|
| Nov 23, 2012 at 11:22 | history | answered | Katafalkas | CC BY-SA 3.0 |