hi all...

i have a 5.0.33 build from source on a freebsd 4.10 machine...

i'm looking for a my.cnf file.

ps tells me that the base dir is /usr/local but there is no my.cnf
there. and i cant find one anywhere.
i can get all the variables set up from the cli but i need to change
some of them. i guess i can use mysqladmin but just wondering - can i
just do a cnf under /usr/local/etc with the variables i need to change?

ktrace is showing me that mysqld is not looking for any .cnf?!

i mean i can try that but it's a very busy server and i wouldn't mess to
much with it.

thanks...

I had the same problem. I found the distribution contains some prototypes,
with slightly more elaborate names.

Regards,
Mike



kalin m <kalin@el.net>
03/18/08 01:06 PM

To
mysql@lists.mysql.com
cc

Subject
default my.cnf?






hi all...

i have a 5.0.33 build from source on a freebsd 4.10 machine...

i'm looking for a my.cnf file.

ps tells me that the base dir is /usr/local but there is no my.cnf
there. and i cant find one anywhere.
i can get all the variables set up from the cli but i need to change
some of them. i guess i can use mysqladmin but just wondering - can i
just do a cnf under /usr/local/etc with the variables i need to change?

ktrace is showing me that mysqld is not looking for any .cnf?!

i mean i can try that but it's a very busy server and i wouldn't mess to
much with it.

thanks...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mspreitz@us.ibm.com

Hi,

On Tue, Mar 18, 2008 at 1:06 PM, kalin m <kalin@el.net> wrote:
> hi all...
>
> i have a 5.0.33 build from source on a freebsd 4.10 machine...
>
> i'm looking for a my.cnf file.
>
> ps tells me that the base dir is /usr/local but there is no my.cnf
> there. and i cant find one anywhere.
> i can get all the variables set up from the cli but i need to change
> some of them. i guess i can use mysqladmin but just wondering - can i
> just do a cnf under /usr/local/etc with the variables i need to change?
>
> ktrace is showing me that mysqld is not looking for any .cnf?!
>
> i mean i can try that but it's a very busy server and i wouldn't mess to
> much with it.

You can ask mysqld where it looks for its configuration files. Here's
a Debian system:

baron@tigger ~ $ mysql -- --verbose | grep cnf
/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf