* Scott Haneda
[...]
> * Roger Baklund
> > For information on the options files:
> >
> > <URL: http://www.mysql.com/doc/en/Option_files.html >
[...]

> Where do all my defaults come from if my.cnf only has
> datadir=/usr/local/mysql/data

Like the link describes, there are multiple my.cnf files, mysql reads them
all. If you only have datadir in one of them, you could still have other
options in other active option files.

> And can I just add in more vars to that file and not harm
> anything, or will I then need to define all the vars.

Depends on which option file you edit. From the link above:

"MySQL tries to read option files in the order listed above. If multiple
option files exist, an option specified in a file read later takes
precedence over the same option specified in a file read earlier."

--
Roger


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to