RE: Turn off log-bin without restarting database

2003-07-10 Thread Andrew Braithwaite
: Ian 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,

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] -->

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 binlo