Changing the location of my.ini and the order option files are read

------=_Part_59358_2937976.1223295563798
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I added a line to the [mysqld) group
As --defaults-file="C:\WINDOWS\my.ini" and then I restarted the
service.Everything was fine.Then I took out the my.ini file in the MySQL
instalation directory the result was an error message AS

Could Not start the MySQL Service on Local Computer

Error 1067 The preocess terminated unexpectedly

According to the manual MySQL server reads option files in the order

Default options are read from the following files in the given order:
C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\Program
Files\MySQL\MySQL Server 5.0\my.ini C:\Program Files\MySQL\MySQL Server
5.0\my.cnf


To see the order I ran the command mysqld-nt --verbose --help
If the optin files read order is as above why can,t get the service started

Varuna

------=_Part_59358_2937976.1223295563798--