List:General Discussion« Previous MessageNext Message »
From:Marcus Bointon Date:October 17 2006 4:37pm
Subject:Removing DBs from replication
View as plain text  
I have a replication setup with two servers. How can I remove one of  
the replicated databases from replication so it's available on only  
one server? All DBs are replicated and there are no replicate-do-db  
options set. I've tried setting replicaten-do-db for all DBs except  
the one I want to remove, and setting replicate-ignore-db, but it  
doesn't 'unreplicate' it - after a restart, do and ignore columns are  
still empty in show master status. What else do I need to do?

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
marcus@stripped | http://www.synchromedia.co.uk/


Thread
Removing DBs from replicationMarcus Bointon17 Oct