Re: Turn of bin log for a session

2005-11-15 Thread Gleb Paharenko
Hello. SQL_LOG_BIN session variable is what you want. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/set-option.html Jeff wrote: > Hey all, > > I need to do some repairs on a replication master/slave and can't > remember the command to turn off bin logging on the master fo

Re: Turn of bin log for a session

2005-11-15 Thread Paul DuBois
At 14:07 -0500 11/15/05, Jeff wrote: Hey all, I need to do some repairs on a replication master/slave and can't remember the command to turn off bin logging on the master for a single session. Set session log_bin = off; Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN' MySQ

Turn of bin log for a session

2005-11-15 Thread Jeff
Hey all, I need to do some repairs on a replication master/slave and can't remember the command to turn off bin logging on the master for a single session. Set session log_bin = off; Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN' MySQL ver 4.1.13 Thanks, Jeff -- MySQ