David,
The server and 8 command-line utilities (mysqladmin, mysqldump, mysqlimport,
mysqlshow, mysqlcheck, myisamchk, mysqlhotcopy and myisampack) read MySQL
option files. Under Linux, they read options from /etc/my.cnf, and under
Windows they read from c:\windows\my.ini and c:\my.cnf, in that order.
The server reads from the [mysqld] section of the file. Utilities and all
clients read from the [client] section of these files. Utilities also read
from an options file section named after themselves, so for example
mysqladmin reads from a [mysqladmin] section, if present.
You can use command line arguments to tell the server and these utilities
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.
PB
-----
> Peter, et al --
>
> ...and then Peter Brawley said...
> %
> % Did you touch up my.cnf/ini to enable InnoDB?
>
> Oh, yeah -- can I do that on a per-user basis or is that for the whole
> database system?
>
>
> %
> % PB
>
>
> Thanks again & HAND
>
> mysql query,
> :-D
> - --
> David T-G * There is too much animal courage in
> (play) [EMAIL PROTECTED] * society and not sufficient moral courage.
> (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and
Health"
> http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD4DBQE96moiGb7uCXufRwARAl9CAJdOfMmiPhTmLpCRHBHNVpW+0kqPAKCcw3Ox
> WZBnKmovtOaD8pSIV62IgQ==
> =TKqK
> -----END PGP SIGNATURE-----
>
>
---------------------------------------------------------------------
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
