Re: my.cnf mystery

2001-06-13 Thread Paul DuBois
At 2:30 PM -0400 6/13/01, Dennis wrote: >At 08:30 PM 06/12/2001, Philip Mak wrote: >>[client] >>port=3306 >>socket=/home/mysql/mysql.sock >> >>[mysqld] >>port=3306 >>socket=/home/mysql/mysql.sock > > >here are examples of variables that you could not deduce from using >--help. the "socket" one,fo

Re: my.cnf mystery

2001-06-13 Thread Dennis
At 08:30 PM 06/12/2001, Philip Mak wrote: >[client] >port=3306 >socket=/home/mysql/mysql.sock > >[mysqld] >port=3306 >socket=/home/mysql/mysql.sock here are examples of variables that you could not deduce from using --help. the "socket" one,for example, was one that I asked about last week, whe

Re: my.cnf mystery

2001-06-13 Thread quarlewm
My point was that this is a configuration file, text, not a program. Still, there should be an appendix in the documentation that lists all of the options rather than have this hunt-and-seek approach. Quoting Paul DuBois <[EMAIL PROTECTED]>: > At 8:15 PM -0400 6/12/01, William M. Quarles wrote

Re: my.cnf mystery

2001-06-12 Thread William M. Quarles
The command lines are divided up by topics in the manual, I think. I know that there is a specific section on replication. A table of all of them in one place would be a helpful appendix in a future edition of the documentation. [hint, hint, MySQL AB developers...] --On Tuesday, June 12, 20

Re: my.cnf mystery

2001-06-12 Thread Paul DuBois
At 8:15 PM -0400 6/12/01, William M. Quarles wrote: >Which program? Uh ... what? mysqld, mysql, mysqladmin, mysqldump, mysqlshow, ... For example, if you run mysql --help, the output includes: Possible variables for

Re: my.cnf mystery

2001-06-12 Thread Philip Mak
On Tue, 12 Jun 2001, William M. Quarles wrote: > Which program? Here's what the /etc/my.cnf file on my system looks like: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock The first section affects the "mysql" client. The second section affects

Re: my.cnf mystery

2001-06-12 Thread William M. Quarles
Which program? --On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: > At 4:34 PM -0400 6/12/01, William M. Quarles wrote: >> I don't think that's what Dennis person wants to know, I think he >> wants to know every single variable that he can control in my.cnf. > > Runni

Re: my.cnf mystery

2001-06-12 Thread Paul DuBois
At 4:34 PM -0400 6/12/01, William M. Quarles wrote: >I don't think that's what Dennis person wants to know, I think he >wants to know every single variable that he can control in my.cnf. Running a program with the --help option will list the program's variables. The syntax for setting any of th

Re: my.cnf mystery

2001-06-12 Thread William M. Quarles
I don't think that's what Dennis person wants to know, I think he wants to know every single variable that he can control in my.cnf. --On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: > At 3:36 PM -0400 6/12/01, Dennis wrote: >> Of the many mysql resources I have

Re: my.cnf mystery

2001-06-12 Thread Paul DuBois
At 3:36 PM -0400 6/12/01, Dennis wrote: >Of the many mysql resources I have (including a book and searching >the website), there doesnt seem to be a definitive outline of what >variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable tha