Preface #1: Hi MySQL Admin!
There's an oddity at http://www.mysql.com/doc/. Entering my.cnf returns no
hits. Entering cnf returns all relevant hits.
Preface #2: Hi All!
Folks, this is the *best* online documentation I have ever ever seen. You
can save youself lotsa time waiting for replies here (if there's even
gonna -be- a reply!) by checking there -first- and then if there's
something you don't understand name the page and why you don't understand
it. This is also one of the best user supported lists around but again
only if someone else care to write something, and you can understand the
answer.
You can even add comments to the docs! I haven't tried it yet, it's a
'register by your email address' thing, but this is a -great- idea to
build FAQs right into the docs. I'm impressed.
I'm not a 'RTFM-you-wimdit-and-go-away' kinda guy. I answer questions
-and- point to the relevant docs. You'll almost never see me ask a
question because I read all the traffic here, look through the books, and
search the docs and the net (google and groups.google) intensively before
posting anywhere. It works 99.64% of the time. The ML search but is a PITA
and that's a can of worms I don't care to open here.
Seriously, the online docs are fantastic.
In any case Hello Christopher!
> > Actually yes (if I read the documentation correctly - I have not tried
> > this).
> > In MySql Manual section "4.10.5 Replication Options in my.cnf", I find:
> > binlog-do-db=database_name
> > Tells the master it should log updates for the specified
> > database, and exclude all others not explicitly mentioned.
> > (Example: binlog-do-db=some_database)
> Will (& Others):
>
> So what you are essentially saying is that I can use the my.cnf file to turn
> on my own options. That makes sense.
>
> Can anyone help me sort out what the my.cnf file would look like?
That's waaaay to much to go into here generically. See
http://www.mysql.com/doc/ and enter cnf. The first two hits contain all
the gruesome details.
In addition to binlog-do-db you'll probably also need to define log-bin to
a path you have write permission.
Jeremy posted simply 'No' but
http://www.mysql.com/doc/O/p/Option_files.html says that ~/.my.cnf
overrides previous cnf options. The server can override the user at the
command line but only trying it can prove whether it works or not.
Have a :) day!
jb
--
jim barchuk
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
