How to restore a slave from a mysql backup?
Posted
by
robsf
on Stack Overflow
See other posts from Stack Overflow
or by robsf
Published on 2012-06-19T01:48:17Z
Indexed on
2012/06/20
3:16 UTC
Read the original article
Hit count: 108
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?
© Stack Overflow or respective owner