cancel
Showing results for 
Search instead for 
Did you mean: 

mysql administration

prem_4
Occasional Advisor

mysql administration

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?
4 REPLIES
Jim Mallett
Honored Contributor

Re: mysql administration


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

Hindsight is 20/20
prem_4
Occasional Advisor

Re: mysql administration

thanx jim,

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

Re: mysql administration

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
Hindsight is 20/20
Yogeeraj_1
Honored Contributor

Re: mysql administration

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)