At 11:02 -0600 12/15/04, Randy Paries wrote:
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There was no my.cnf in the /etc dir, so I created one from my-huge.cnf and
placed it in the /etc
But the startup does not use it.
Run "mysqld --help" and look at the help message to see what option
files the server thinks it's supposed to read. One possibility is
that it reads /etc/mysql/my.cnf instead of /etc/my.cnf -- I believe
some vendors hack MySQL to change the location of the global option
file.
So I tried to append the same command to the mysql script that is called
from init.d
--defaults-file=/etc/my.cnf and I get the error
041215 10:51:59 mysqld started
/usr/sbin/mysqld: ERROR: unknown variable 'defaults-file=/etc/my.cnf'
041215 10:51:59 mysqld ended
The probable cause of this is that --defaults-file is not the first
option.
That part that confuses me is in the script /etc/rc.d/init.d/mysqld
(I put in some debug echos to see where it is exiting)
When I run the startup it print "2"
But I am not failure with /usr/bin/my_print_defaults
Thanks for any help!
Randy
==============================SNIP===================================
# Get arguments from the my.cnf file,
# groups [mysqld] [mysql_server] and [mysql.server]
if test -x ./bin/my_print_defaults
then
echo "1"
print_defaults="./bin/my_print_defaults"
elif test -x $bindir/my_print_defaults
then
echo "2"
print_defaults="$bindir/my_print_defaults"
elif test -x $bindir/mysql_print_defaults
then
echo "3"
print_defaults="$bindir/mysql_print_defaults"
else
echo "I am here"
# Try to find basedir in /etc/my.cnf
conf=/etc/my.cnf
print_defaults=
if test -r $conf
then
subpat='^[^=]*basedir[^=]*=\(.*\)$'
dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
for d in $dirs
do
d=`echo $d | sed -e 's/[ ]//g'`
if test -x "$d/bin/my_print_defaults"
then
print_defaults="$d/bin/my_print_defaults"
break
fi
if test -x "$d/bin/mysql_print_defaults"
then
print_defaults="$d/bin/mysql_print_defaults"
break
fi
done
fi
# Hope it's in the PATH ... but I doubt it
test -z "$print_defaults" && print_defaults="my_print_defaults"
Fi
==============================SNIP===================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
