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 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 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 -->binlog-do-db=maindata -->replicate-do-db=maindata --> -->-- --> -->Many Regards, -->Ian Collins -->System Manager -->KIWIPLAN NZ Ltd. -->================ --> --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
