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]