MySQL Forums
Forum List  »  Replication

Restore slave using backup files
Posted by: Jørn Dahl-Stamnes
Date: May 10, 2019 06:20AM

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?

Options: ReplyQuote

Written By
Restore slave using backup files
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.