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

[15 Oct 2003 10:04] Jim Scott
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.
[15 Oct 2003 10:15] Paul DuBois
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.
[15 Oct 2003 10:22] Jim Scott
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 ...
[15 Oct 2003 10:56] Paul DuBois
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?
[15 Oct 2003 11:05] Jim Scott
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!
[15 Oct 2003 11:18] Paul DuBois
Okay, I'm glad to hear that it's working now. I will close this report. Thanks.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.