I have a Master & Slave setup. Embarrassingly I managed to execute some data changing statements (INSERT and UPDATEs across 3 tables) on the Slave. Obviously this stopped the Slave replication.
I don't need the updates I accidentally made on the Slave. How can I get it back in sync with the Master?
Best Answer
you run this in slave host (pdb-0001 is remote Master DB)