On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote:
> At 03:01 PM 7/9/2001 -0700, you wrote:
> >On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > > > We do a few large daily and monthly downloads from an Oracle database
> > > > server. Is there a way to exclude these specific queries from the
> > > > update/binary log??
> > >
> > > If the queries only affect one table or database, use the
> > > replication ignore options listed here:
> > > http://www.mysql.com/doc/R/e/Replication_Options.html
> >
> >Better yet, check this page:
> >
> > http://www.mysql.com/doc/R/e/Replication_SQL.html
> >
> >And look at "SET SQL_LOG_BIN=0"
>
> Does this turn off logging for everything (all other connections) or
> only for the current connection??
Hmm. Good point. I hadn't thought about that. And the manual
doesn't say one way or the other, so I assume it's a global setting.
This might not be what you want aferall.
But it would be useful to be able to do this on a per connection
basis. Perhaps some testing is in order.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 24 days, processed 183,699,039 queries (87/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php