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]

Reply via email to