Turn off log-bin without restarting database

2003-07-10 Thread Ian Collins
I want to turn off replication logging (we have stopped using replication) without shutting down the server. (The only downtime allowed is about 2am, and I needmy sleep). I couldn't see how to do this in the docs. Is it possible? The variables in my /etc/my.cnf are, log-bin server-id=1000

RE: Turn off log-bin without restarting database

2003-07-10 Thread Dathan Vance Pattishall
CHANGE MASTER TO MASTER_LOG_HOST='', MASTER_LOG_POS='', MASTER_LOG_PORT=''; SLAVE STOP; SHOW SLAVE STATUS; ---Original Message- --From: Ian Collins [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 10, 2003 4:59 PM --To: [EMAIL PROTECTED] --Subject: Turn off log-bin without restarting

RE: Turn off log-bin without restarting database

2003-07-10 Thread Andrew Braithwaite
Collins [mailto:[EMAIL PROTECTED] Sent: Friday 11 July 2003 00:59 To: [EMAIL PROTECTED] Subject: Turn off log-bin without restarting database I want to turn off replication logging (we have stopped using replication) without shutting down the server. (The only downtime allowed is about 2am, and I