In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery.
I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog post. Here is a quick summary of the approach:
- Restore the backup on the desired server
- Create a fake master
- Copy all relevant binlogs to the fake master
- Configure server from the first step as a slave from a fake master
In addition to the above steps, there is a similar approach …[Read more]