I had sent this earlier, but it got waylaid (twice). Perhaps the mail-
server was temporarily down.
----------------------------------------------------------------
Okay, I got rid of EVERYTHING (except the data, which got backed up
in douplicate), and did a fresh install from a tarball, following the
directions exactly, except the mysql user and group were already
there.
When I got to bin/safe_mysqld --user-mysql & it ran, and the deamon
ended. I checked the error file, and it told me:
010224 11:04:45 mysqld started
010224 11:04:45 Can't start server: Bind on TCP/IP port: Address
already
in use 010224 11:04:45 Do you already have another mysqld server
running on port: 3306 ? 010224 11:04:45 Aborting
010224 11:04:45 mysqld ended
So, I did a ps aux | grep mysql > path-to-file, and got:
1789 0.0 0.8 11528 1368 ? S 20:30 0:00 /usr/sbin/mysqld
--ba mysql
1791 0.0 0.8 11528 1368 ? S 20:30 0:00
/usr/sbin/mysqld --ba mysql
1792 0.0 0.8 11528 1368 ? S 20:30
0:00 /usr/sbin/mysqld --ba root
20027 0.0 0.3 1240 492 ? S 19:49 0:00 grep mysql
Whoa! I have a daemon already running at /usr/sbin/mysqld?
Is there anything else I need to know about before I start over?
Do I need to start over?
On 23 Feb 2001, at 14:02, John Jensen wrote:
> I do believe I have a mess on my hands.
> Lacking any other guidance, I tried upgrading my mysql to 3.23 with
an
> rpm on a Redhat Linux 6.1 system. I now have the same directory
layout
> for mysql as on my Redhat 7 server, except there is no daemon to be
> found there. The only mysql daemon found anywhere is still in
> /usr/local/mysql/bin, and it still doesn't work. Attempts to
execute
> no longer insist there is supposed to be a libexec directory. It
just
> tells me it can't find any data in the var directory. When I ran
> scripts/mysql_install_db, it just tells me to remember to copy the
> support-files/mysql.server to the right place (wherever that is, if
> not where it is already) and to remember to set a password. That
> doesn't work either. It wants a /tmp/mysql.sock file, and I don't
have
> one to give it.
>
> Any ideas?
>
> On 21 Feb 2001, at 16:29, Atle Veka wrote:
>
> >
> > where's your mysqld located?
> >
> > just change your safe_mysql script to contain the correct
location
> > of your mysqld binary.
> >
> > also, i *think* mysqladmin -uroot -p[pass] shutdown
> > is the preferred shutdown mechanism, didn't even know you could
do
> > that with mysql (client).
> >
> > are you sure it's actually stopped? do a 'ps | grep mysqld' to
find
> > out ;)
> >
> >
> > Atle
> >
> > On Wed, 21 Feb 2001, John Jensen wrote:
> >
> > > I had shut down the mysql daemon using:
> > > bin/mysql -u root -p[password] shutdown
> > > Now when I attempt to restart it using:
> > > bin/safe_mysql &
> > > it gives me the message:
> > > [1] 2564
> > > The file /usr/local/mysql/libexec/mysqld doesn't exist or is
not
> > > executable Please do a cd to the mysql installation directory
> > > and restart this script from there as follows: ./bin/safe_mysql
> > > but ./bin/safe_mysql just gave me the same message prefaced by:
> > > [2] 2570 I checked and found the directory 'libexec' does not
> > > exist. I can't recall it ever did. So now I am left wondering:
> > > "Why is it trying to look in a non-existent direcory?" and
"What
> > > went wrong?"
> > >
> > > Any ideas?
> > >
> > > ----------------------------------------------------------------
John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php