Re: Restoring Binary Logs from backup
Posted by: shane man
Date: November 09, 2005 03:09PM

I Found that "SET SQL_LOG_BIN=0" before applying sql statements prevents those statements being logged to the binary logs, but it affects the whole server.

Is there a more granular method of disabling binary logging for a particular database without restarting the mysql service?

Thanks again.

Options: ReplyQuote


Subject
Views
Written By
Posted
782
November 09, 2005 02:29PM
Re: Restoring Binary Logs from backup
387
November 09, 2005 03:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.