This is an automated archive.
The original was posted on /r/mysql by /u/dbaquest on 2023-12-01 18:47:27+00:00.
Hi, I’m currently trying to replicate from an older binary log file, just to prepare for errors, in which case I would have to reset from an older file.
This is what I’m doing so far.
Sync master and slave (note down the master log file and master log pos).
Insert record on master.
Verify that slave has the newly added record.
Delete newly added record on slave.
Reset slave config to point to the master log file and master log pos I noted down earlier.
Check to see if the record has been added again.
So far, all the steps except the last one seem to be working. When I reset the slave config to the older master log file (before we added the new record), the new record doesnt get added again on the slave. Am I doing something wrong? How do I proceed with this?