Restore slave using backup files
I have a question about the slave in a master slave setup.
Is it possible to reinstall the slave using dump from the same slave? Something like:
mysql slave> stop slave;
mysql slave> flush tables;
mysql slave> show slave status\G ## STORE THIS INFO FOR LATER USER
# mysqldump <dump all relevants databases>
Then delete everything and reinstall from scratch, restore the dump and then user the info from the show slave status command done before the dump to start master-slave sync?
Subject
Views
Written By
Posted
Restore slave using backup files
1085
May 10, 2019 06:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.