> Where is the config file for MySQL on windows? Is that where I tell it to
> use a log file? By default is it off? Thank you.
Under Linux, MySQL server executables and eight MySQL utulities read options
from /etc/my.cnf, and under Windows they read from c:\windows\my.ini and
c:\my.cnf, in that order. You can also use command line arguments to tell
these programs which configuration file(s) to read, or to read no
configuration file at all:
--defaults-file=fileName
This tells the utility to read options from fileName.
--defaults-extra-file=fileName
This tells the utility to read fileName after reading the global option
file(s).
--no-defaults
This tells the utility to read no option file.
They read from the [client] section of these files, and in addition from an
options file section named after themselves, so for example mysqld* reads
frm a [mysqld] section, mysqladmin reads from a [mysqladmin] section, if
present, and so on.
Program options that are settable in my.cnf/ini are commands or settings
that are single words, for example check, or hyphenated word sequences, for
example update-state. If the option sets a variable, the syntax is:
[set-variable=]varName=value
In general, server executables and utilities that can read settings and
commands from option files also accept command-line arguments which are
simply those same options prefixed with a double hyphen, for
example --check, --update-state. In many cases the program also recognises
single-character abbreviations of such commands, for example -c
for --check, -U for --update-state, and -O for --set-variable=, and these
abbreviations can be concatenated, for example -cU.
hth
PB
---------------------------------------------------------------------
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
