by The reason is that if 'basedir' is read from 'my.cfg' then 'bindir'
is not set to $basedir/bin but to /compile-time-dir/bin
1) Install mysql in a directory other than the one for which it was compiled.Quote:>How-To-Repeat:
2) Configure /etc/my.cnf to work with this new directory
[mysqld]
basedir=new-base
datadir=new-data-dir
pid-file=new-data-dir/mysql4.pid
[mysqld_safe]
ledir=new-base/libexec
3) run 'mysql.server' and you get this message
Can't execute /compile-time-dir/bin/mysqld_safe from dir new-base
In the file : mysql.serverQuote:>Fix:
after the line: parse_arguments `$print_defaults mysqld mysql_server mysql.server`
add this line : bindir=$basedir/bin
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult ABQuote:>Submitter-Id: <submitter ID>
>Originator: Jean Fontayne
>Organization: UUNET
>MySQL support: none
>Synopsis: cannot start mysql if installed outside the 'compile time' directory
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.12 (Source distribution)
>Server: /prod/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for sun-solaris2.8 on sparc
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.12
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 min 25 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002
System: SunOS ipmsdsrc1.ams.ops.eu.uu.net 5.8 Generic_108528-15 sun4u sparc SUNW,UltraAX-i2Quote:>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
Architecture: sun4
Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/vendor/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' ASFLAGS=''
LIBC:
-rw-r--r-- 1 root 2 1764552 Jun 3 2002 /lib/libc.a
lrwxrwxrwx 1 root root 11 Aug 21 2002 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root 2 1146204 Jun 3 2002 /lib/libc.so.1
-rw-r--r-- 1 root 2 1764552 Jun 3 2002 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Aug 21 2002 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root 2 1146204 Jun 3 2002 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-assembler' '--with-extra-charsets=complex' '--enable-thread-safe-client' '--with-innodb' '--with-berkeley-db' '--with-embedded-server' '--with-openssl' '--with-vio' '--enable-local-infile' 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXX=gcc'
Perl: This is perl, version 5.005_03 built for sun4-solaris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql