CODEWITHSUNDEEP
mysqldatabase-replication
Vinny
Vinny

Reputation: 11

Mysql replication undo change master on master host

i ran change master command on master host that should not be run. (Gave parameteres like master host, master password, bin log filename etc). Can i undo this ? Can i just run reset slave and remove master.host file without stopping mysql? Will it get replicated to the existing slave hosts? because this is a master host that is already replicating to multiple slaves.

please advise Thank you

Upvotes: 1

Views: 1224

Answers (1)

tike
tike

Reputation: 548

You can delete your master.info file.

for example

if you have my.cnf file saying

master-info-file     = master.info

than delete, rm -rf /var/lib/mysql/master.info

Upvotes: 1

Related Questions