my.cnf and binary distributions
is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf the problem is at my company i am not allowed to install things as root, so i can't put files in /etc or /usr/local/mysql/data. the problem with the home directory option is the mysql user is a role account with no home directory. also the server is usually started via sudo which doesn't necessarily set the home directory properly. i could write a shell script that sets $HOME and calls mysqld but then that's another thing to maintain. the company likes to build their own rpm's of mysql but their track record hasn't been so good lately (the 4.0.14 rpm crashed and burned instantly.) i've got an app which is suffering from random table corruption, which is supposedly fixed in 4.0.15a. i'd like to stick with the official binaries (that seems like a really good idea to me in general anyway) but this my.cnf issue is kind of a drag. suggestions? -jsd- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf and binary distributions
At 10:42 AM -0700 9/19/03, Jon Drukman wrote: is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf No, but if you have control over how the server gets started, you can invoke it with a --defaults-file option to tell it to ignore the standard option files and specify a file of your own choosing. the problem is at my company i am not allowed to install things as root, so i can't put files in /etc or /usr/local/mysql/data. the problem with the home directory option is the mysql user is a role account with no home directory. also the server is usually started via sudo which doesn't necessarily set the home directory properly. i could write a shell script that sets $HOME and calls mysqld but then that's another thing to maintain. the company likes to build their own rpm's of mysql but their track record hasn't been so good lately (the 4.0.14 rpm crashed and burned instantly.) i've got an app which is suffering from random table corruption, which is supposedly fixed in 4.0.15a. i'd like to stick with the official binaries (that seems like a really good idea to me in general anyway) but this my.cnf issue is kind of a drag. suggestions? -jsd- -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf and binary distributions
At 11:13 AM 9/19/2003, Paul DuBois wrote: At 10:42 AM -0700 9/19/03, Jon Drukman wrote: is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf No, but if you have control over how the server gets started, you can invoke it with a --defaults-file option to tell it to ignore the standard option files and specify a file of your own choosing. thank you very much. that's exactly what i've been looking for! i tried grepping for config file and my.cnf all over the place. you might want to somehow indicate that in the help message. there's no indication that defaults file = my.cnf anywhere. -jsd- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf and binary distributions
At 11:30 AM -0700 9/19/03, Jon Drukman wrote: At 11:13 AM 9/19/2003, Paul DuBois wrote: At 10:42 AM -0700 9/19/03, Jon Drukman wrote: is there any way to get mysqld 4.0.15a from the linux binary distribution to use another path for my.cnf apart from /etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf No, but if you have control over how the server gets started, you can invoke it with a --defaults-file option to tell it to ignore the standard option files and specify a file of your own choosing. thank you very much. that's exactly what i've been looking for! i tried grepping for config file and my.cnf all over the place. you might want to somehow indicate that in the help message. there's no indication that defaults file = my.cnf anywhere. mysqld --help -jsd- -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]