MySQL weirdness

[djbeta]

This is weird..
my
MySQL seems to be running OK
I'm running version 4.0.15
several databases are working perfectly via
their respective web applications..

In Mac OS 10.3.9, when I open Terminal,
I can "cd usr/local"
and when I do an "ls"
I see mysql in there.. but when I try to "cd mysql"
it tells me no such file or directory

What Gives ???

when I run "ls -la" in /usr/local ?

I see this for mysql:

lrwxr-xr-x 1 root wheel 45 9 Nov 2004 mysql -> mysql-standard-4.0.18-apple-darwin6.8-powerpc

first of all, what is that -> arrow..
that's weird.. phpmyadmin said I was running 4.0.15

Perhaps I screwed things up when trying to upgrade my MySQL
Any advice on how to proceed with this or wipe things clean/reinstall while preserving the databases ? thx.

 

[ksv]

This is weird..
my
MySQL seems to be running OK
I'm running version 4.0.15
several databases are working perfectly via
their respective web applications..

In Mac OS 10.3.9, when I open Terminal,
I can "cd usr/local"
and when I do an "ls"
I see mysql in there.. but when I try to "cd mysql"
it tells me no such file or directory

What Gives ???

when I run "ls -la" in /usr/local ?

I see this for mysql:

lrwxr-xr-x 1 root wheel 45 9 Nov 2004 mysql -> mysql-standard-4.0.18-apple-darwin6.8-powerpc

first of all, what is that -> arrow..
that's weird.. phpmyadmin said I was running 4.0.15

Perhaps I screwed things up when trying to upgrade my MySQL
Any advice on how to proceed with this or wipe things clean/reinstall while preserving the databases ? thx.

/usr/local/mysql is a symbolic link to the actual mysql installation. Because the installation is not in place anymore, mysql points to nowhere.

Are there any other mysql- directories in /usr/local? If so, create a new symbolic link to it:

cd /usr/local
ln -s mysql-installation mysql

Replace 'mysql-installation' with the actual directory name of the installation, like mysql-standard-4.0.15-apple-darwin6.8-powerpc.

I think the official MySQL installer packages do this automatically.