Re: Newby resetting replication query

[ian diddams]

so - to clarify...

M=master
S=Slave
Database name is bugtracker = B for simplicity

M and S run B, and rep-0lication isnin place.

I break replication so M & S are running seprrately. S then gets used as "live" (DR scenario).
S database B is now "ahead" of M.

I dump B from S, import B on M. Now B is the same on both M & S.

I recreate replication.



So are you saying having imported B to M I then dump it on M and import it on S - even though it "has" to be the same. Or are you meaning dump _everything" on M and import to S

eg
on S mysqldump -u root -p --databases bugtracker > bugdump.db
on M MySQL -u root -p bugtracker < bugdump.db

and THEN

on M mysqldump -u root -p --all-databases > all_dump.db
on S mysql -uroot -p < all_dump.db

them recreate replication
?

cheers