Have you considered 'RESET SLAVE'?
http://dev.mysql.com/doc/refman/5.0/en/reset-slave.html
--
Augusto Bott
On Feb 19, 2008 11:21 AM, Marcus Bointon <marcus@stripped> wrote:
> I have a circular replication setup that I want to stop, leaving just
> one master. The (irreparably out of sync) second master has been
> stopped for a while, and I want to abandon all changes that are
> pending for it, wipe any pending logs, remove its databases prior to
> rebuilding it. How do I safely deactivate secondary master references
> on the primary? On the primary master I can do "stop slave", but I
> want to make sure that it won't attempt to reconnect to the secondary
> master if I restart it and won't execute functions from the secondary
> that are part of the cleanup process (which could be fatal to the real
> DB).
>
> Marcus
> --
> Marcus Bointon
> Synchromedia Limited: Creators of http://www.smartmessages.net/
> UK resellers of info@hand CRM solutions
> marcus@stripped | http://www.synchromedia.co.uk/
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
>
>
