Where is mysql config file?

[ThE-KinG]

Hello friends,

How can I find my.cnf file on plesk 7.5.3. Normally It was in the /etc but I haven't found in there.

server# find my.conf
find: my.conf: No such file or directory
server# find my.cnf
find: my.cnf: No such file or directory

mySQL version is 4.1 and OS is freebsd : ).

Thank you so much for your replies.

 

[ThE-KinG]

Any idea?

- Thanks

 

[WebDork]

[root@angusserver4 root]# locate my.cnf
/etc/my.cnf
/etc/my.cnf-original

 

[ThE-KinG]

root# locate my.cnf
root#

Could you please include your my.cnf file here.

I will re-create this file on my machine.

 

[WebDork]

Better if you use the examples on your own server...

eg

[root@www root]# locate my-large.cnf
/usr/share/doc/mysql-server-4.0.23a/my-large.cnf

The files in this dir (in my case):
/usr/share/doc/mysql-server-4.0.23a/

are sample files that probably work best for your setup. But make a backup of your original just in case.

 

[ThE-KinG]

I have found,

my-huge.cnf
my-innodb-heavy-4G.cnf
my-large.cnf
my-medium.cnf
my-small.cnf

In /usr/local/psa/mysql/share/mysql

I copied my-medium.cnf as my.cnf in the /etc folder. Working without problem now.

Thanks.