Hi, If you are using unix, comment out those lines and set a cron job for 2am to do the server restart for you...
If you're using windows then comment out the lines and set ?schedule? (or whatever the ms equiv is) to do the restart at 2am. Cheers, Andrew -----Original Message----- From: 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, 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]