mysql administration

[prem_4]

hi
i thank u all for ur replies for my previous question.

presently i am working on linux8.0
the my.cnf file is stored in /etc/my.cnf
like-same where is it stored in windows OS?

[Jim Mallett]

Default is c:\my.cnf

For more info on your question:
http://www.mysql.com/doc/en/Option_files.html

For more info on MySQL:
http://www.mysql.com

Jim Mallett

[prem_4]

thanx jim,

is there any other doc in MySql that shows all the file location details for both linux and windows

[Jim Mallett]

prem,

i'm not familiar with the particulars of mysql, i only have experience w/ oracle and sql server. here is what i found searching the manual though, hope it helps:

http://www.mysql.com/doc/en/Installation_layouts.html

Jim

[Yogeeraj_1]

hi,

my.cnf is usually placed in:

DATADIR/my.cnf

on Unix systems (DATADIR is the directory specified when the system was configured), or C:\mysql\data\my.cnf on Windows systems. The file can be placed elsewhere if you have more than one MySQL server running, or want to specify different options down to a user level, but having one set of values per server is usually sufficient.

hope this helps!
regards
Yogeeraj