Timeline for MySQL replication: "Houston, We've Got a Problem"
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 15, 2012 at 16:22 | comment | added | RolandoMySQLDBA | Looks like Houston can stop worrying now. +1 !!! | |
| Feb 15, 2012 at 14:13 | vote | accept | Katafalkas | ||
| Feb 15, 2012 at 14:13 | vote | accept | Katafalkas | ||
| Feb 15, 2012 at 14:13 | |||||
| Feb 15, 2012 at 14:13 | comment | added | Katafalkas | Its me again, I think I solved it, I added a replicate-ignore-table=database2.tbl%, so it seems to be working so far ... Cheers for the idea :D | |
| Feb 15, 2012 at 13:49 | comment | added | Katafalkas |
Hi. Yes the error code is 1146. I dont think that the replicate-ignore-db=database2 will work, as code igniter selects the database1 to start with. But now when I look at it, you give me an idea: there is also a replicate_ignore_table, I could set that to database2.tbl40. and the replicate_wild_ignore_table is something that could be usefull.
|
|
| Feb 15, 2012 at 13:36 | history | answered | Aaron Brown | CC BY-SA 3.0 |