[EMAIL PROTECTED] wrote: > Hello colleagues, > Im'using the MySQL 3.23, > I've found the following commands > SET SQL_LOG_BIN=0 Disables update logging if the user has process > privilege. Ignored otherwise. (Master) > SET SQL_LOG_BIN=1 Re-enables update logging if the user has process > privilege. Ignored otherwise. (Master) > > in the http://www.scit.wlv.ac.uk/appdocs/mysql/manual_toc.html manual ... > > I suppose they enable/disable the binary log production, is it right? I > mean: all the log production, not just for the current client, is it right?? > . > > Why they don't work properly???
What exactly doesn't work? Dont' forget that SET SQL_LOG_BIN enables/disables binary logging for the _current_ connection. > > Which is the right way to enable / disable ALL the LOG production at run > time, if any? If MySQL server is running without --log-bin option, you should restart server anyway to enable binary logging. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
