From: JRough on
This is my current .bash_login:
export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:
$PATH"

I need it to be this:
/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

Do I just add the end that is missing of this before the ending :
$PATH"?
/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

I figured out what was wrong. The mysql* in the path is a sym link to
the mysql-5.1.40-osx10.5-powerpc directory so you don't have to type
in the whole thing. I don't know why all this part was missing but
hopefully it will work now. I got this by doing a pwd in the mysql
directory and I guess the sym link adds the rest of it.

thanks,
From: OldSchool on
"I need it to be this:
/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
.
.
.
The mysql* in the path is a sym link to the mysql-5.1.40-osx10.5-
powerpc directory..."

As Jon noted, the directory is probably NOT "/usr/local/mysql*", but
rather "/usr/local/mysql". I'd bet the "*" is an artifact of a GNU
derived "ls" command. You can find out by trying "cd /usr/local/
mysql". if that works, remove the "*" from the above...

The fact that its a symbolic link doesn't matter one way or the
other...i.e. you can use either (provided the symlink is correctly
entered).

one advantage of the using the symlink over the full path is that the
correct full path may change if you subsequently upgrade, while the
symlink *should* remain the same name and always point at the
installation......

From: JRough on
On Dec 22, 1:04 pm, Bill Marcum <marcumb...(a)bellsouth.net> wrote:
> On 2009-12-22, JRough <jlro...(a)yahoo.com> wrote:> This is my current .bash_login:
> > export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:
> > $PATH"
>
> > I need it to be this:
> > /usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
> > usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
>
> > Do I just add the end that is missing of this before the ending :
> > $PATH"?
> > /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
>
> Some of those directories will probably already be in PATH, but it's harmless
> if a directory is listed twice. You can type "echo $PATH" at a command
> prompt to see what is in there.

Well something seems wrong already. There is a scripts directory with
a mysql_install_db script. It doesn't run. I tried it in the script
directory and one level above.
janis-roughs-power-mac-g5:scripts jlrough$ ls
mysql_install_db
janis-roughs-power-mac-g5:scripts jlrough$ mysql_install_db --
user=mysql
-bash: mysql_install_db: command not found
janis-roughs-power-mac-g5:scripts jlrough$ pwd
/usr/local/mysql/scripts
janis-roughs-power-mac-g5:scripts jlrough$


This is frustrating because I followed the instructions word for
word.
janis-roughs-power-mac-g5:mysql jlrough$ scripts/mysql_install_db --
user=mysql

FATAL ERROR: Could not find mysqld

The following directories were searched:

/usr/local/mysql-5.0.82-osx10.5-powerpc/bin//libexec
/usr/local/mysql-5.0.82-osx10.5-powerpc/bin//sbin
/usr/local/mysql-5.0.82-osx10.5-powerpc/bin//bin

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.


Is it the path or because I need to run make and make install?
I tried both of them and that didn't work either.

janis-roughs-power-mac-g5:mysql jlrough$ make
make: *** No targets specified and no makefile found. Stop.
janis-roughs-power-mac-g5:mysql jlrough$ make install
make: *** No rule to make target `install'. Stop.

any ideas would be appreciated.
From: JRough on
On Dec 23, 7:10 am, OldSchool <scott.my...(a)macys.com> wrote:
> "I need it to be this:
> /usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
> usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
>    .
>    .
>    .
> The mysql* in the path is a sym link to the mysql-5.1.40-osx10.5-
> powerpc directory..."
>
> As Jon noted, the directory is probably NOT "/usr/local/mysql*", but
> rather "/usr/local/mysql".  I'd bet the "*" is an artifact of a GNU
> derived "ls" command.  You can find out by trying "cd /usr/local/
> mysql".  if that works, remove the "*" from the above...
>
> The fact that its a symbolic link doesn't matter one way or the
> other...i.e. you can use either (provided the symlink is correctly
> entered).
>
> one advantage of the using the symlink over the full path is that the
> correct full path may change if you subsequently upgrade, while the
> symlink *should* remain the same name and always point at the
> installation......

Well thanks that did something. It does have a sym link so you don't
have to type the long directory name. I was able to try to start the
mysql
demon but it still seems like it still has some path issues.

sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql

091223 09:59:48 mysqld_safe Logging to '/usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-
g5.local.err'.
touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
roughs-power-mac-g5.local.err: No such file or directory
chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
roughs-power-mac-g5.local.err: No such file or directory
091223 09:59:49 mysqld_safe Starting mysqld daemon with databases
from /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 137: /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
No such file or directory
091223 09:59:49 mysqld_safe mysqld from pid file /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
ended
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
No such file or directory

Is it still the $PATH variable that is wrong and it can't find
something or what? What is line 100 & 137 about? It needs the data
directory which is what I saved from the old install since it has
databases in there. I think the user and groups are right. I am
starting it as _mysql user.
Here is my directory
drwxr-xr-x 17 root _mysql 578 Dec 23 09:54 .
drwxr-xr-x 8 root wheel 272 Dec 22 11:14 ..
-rw-r--r-- 1 root _mysql 19071 Oct 6 15:51 COPYING
-rw-r--r-- 1 root _mysql 5139 Oct 6 15:51 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root _mysql 9439 Oct 6 15:51 INSTALL-BINARY
-rw-r--r-- 1 root _mysql 62989 Oct 6 15:51 README
drwxr-xr-x 46 root _mysql 1564 Oct 6 15:51 bin
drwxr-xr-x 4 _mysql _mysql 136 Dec 23 09:50 data
drwxr-xr-x 4 root _mysql 136 Oct 6 15:50 docs
drwxr-xr-x 34 root _mysql 1156 Oct 6 15:50 include
drwxr-xr-x 22 root _mysql 748 Oct 6 15:51 lib
drwxr-xr-x 4 root _mysql 136 Oct 6 15:50 man
drwxr-xr-x 15 root _mysql 510 Oct 6 15:51 mysql-test
drwxr-xr-x 3 root _mysql 102 Oct 6 15:51 scripts
drwxr-xr-x 35 root _mysql 1190 Oct 6 15:51 share
drwxr-xr-x 29 root _mysql 986 Oct 6 15:51 sql-bench
drwxr-xr-x 16 root _mysql 544 Oct 6 15:51 support-files
From: OldSchool on
On Dec 23, 1:09 pm, JRough <jlro...(a)yahoo.com> wrote:
> On Dec 23, 7:10 am, OldSchool <scott.my...(a)macys.com> wrote:
>
>
>
>
>
> > "I need it to be this:
> > /usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
> > usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
> >    .
> >    .
> >    .
> > The mysql* in the path is a sym link to the mysql-5.1.40-osx10.5-
> > powerpc directory..."
>
> > As Jon noted, the directory is probably NOT "/usr/local/mysql*", but
> > rather "/usr/local/mysql".  I'd bet the "*" is an artifact of a GNU
> > derived "ls" command.  You can find out by trying "cd /usr/local/
> > mysql".  if that works, remove the "*" from the above...
>
> > The fact that its a symbolic link doesn't matter one way or the
> > other...i.e. you can use either (provided the symlink is correctly
> > entered).
>
> > one advantage of the using the symlink over the full path is that the
> > correct full path may change if you subsequently upgrade, while the
> > symlink *should* remain the same name and always point at the
> > installation......
>
> Well thanks that did something.  It does have a sym link so you don't
> have to type the long directory name.  I was able to try to start the
> mysql
> demon but it still seems like it still has some path issues.
>
> sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql
>
> 091223 09:59:48 mysqld_safe Logging to '/usr/local//usr/local/
> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-
> g5.local.err'.
> touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
> roughs-power-mac-g5.local.err: No such file or directory
> chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
> roughs-power-mac-g5.local.err: No such file or directory
> 091223 09:59:49 mysqld_safe Starting mysqld daemon with databases
> from /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data
> /usr/local/mysql/bin/mysqld_safe: line 100: /usr/local//usr/local/
> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
> No such file or directory
> /usr/local/mysql/bin/mysqld_safe: line 137: /usr/local//usr/local/
> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
> No such file or directory
> 091223 09:59:49 mysqld_safe mysqld from pid file /usr/local//usr/local/
> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
> ended
> /usr/local/mysql/bin/mysqld_safe: line 100: /usr/local//usr/local/
> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
> No such file or directory
>
> Is it still the $PATH variable that is wrong and it can't find
> something or what?  What is line 100 & 137 about? ....

lines 100 and 137 appear to refer to those lines in the script " /usr/
local/mysql/bin/mysqld_safe"

the remainder of the errors seem to indicate that it can't find:
"/usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/'

to create files in...but the path names are so attrocious, I'm not
sure..I'd bet it is supposed to be:

"/usr/local/mysql-5.0.82-osx10.5-powerpc/data/"

which may mean there was an error / typo in the installation process,
or that the environment variables aren't properly set-up in the
profile