Jeremy,
I did test it and couldn't get it to work one way or the other....However,
as it turns out, the '--binlog-ignore-db' option will work for me.
Thanks for all your help!!
Phil
At 11:03 AM 7/10/2001 -0700, you wrote:
>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