* 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]