How to restore a slave from a mysql backup?
- by robsf
I'm running MySql 5.1. I have Master and a Slave on 2 machines and I set up replication.
I do periodic backup on my slave server. I stop mysql, I copy all the files and I restart mysql.
In case I lose the Master, I can set up a new one from the last backup.
What If I lose the Slave? Can I restart the slave from the last backup? Am I supposed to keep track of the position of the replication every time I to a backup?