MySQL Bugs: #1562: MySQL is not reading the DATADIR/my.conf file

Bug #1562	MySQL is not reading the DATADIR/my.conf file
Submitted:	15 Oct 2003 10:04	Modified:	15 Oct 2003 11:18
Reporter:	Jim Scott	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.15	OS:	MacOS (Mac OS X)
Assigned to:		CPU Architecture:	Any

Description:
bin-log is set by default in the my.conf file in the datadir.  

When starting mysqld_safe it would not do binary logging.  I made sure that my.conf had the option specified in it.  I also set the server-id=4.  When restarting mysql neither binary logging or server-id were set properly.  I checked to make sure the permissions were correct on the file (and datadir) and that all the paths were correct for the datadir.

I restarted MySQL with the options --log-bin --server-id=4 and the server started up just as expected.

I don't believe that the my.conf file is being read at all on the Mac OS X.  Or if it is, it is not processing all options from the file.

How to repeat:
Install MySQL 4.0.15 on Mac OS X and start the server.  Binary Logging is the default in the my.conf file yet it will not be enabled.

Suggested fix:
Being able to set the options in the my.conf file would be fantastic.

The server doesn't read a file named my.conf.  If you really
have the file named that way, please rename it to my.cnf
and try again.

Ok, well apparently I am a moron and didn't really pay attention to the fact that the file was named improperly.  However what I am now curious about is the fact that this file was in the datadir by default.  I know that the copies of the files exist in the shared dir as my-huge.cnf my-large.cnf etc... how did a file with the wrong name get stuck in the datadir?  Thanks for the quick help ...

I'm curious why that file might be there, too. As far as I know,
our installers do not install any default option file in the
data directory.  You're sure you didn't create it at some
earlier time?

In any event, now that you have renamed the file, is the
server now reading options from it the way you want?

I am positive that the file was there from the installation.  And yes, after I renamed the file everything is working perfectly now. YAY for me .. and in case I didn't mention it before .. Thanks!

Okay, I'm glad to hear that it's working now. I will close this report. Thanks.