Well, I read, played around and updated it (I guess)
Now, when I try to start mysql with this command (same as before), it
gives me that:
# /usr/local/bin/safe_mysqld --user=mysql &
[1] 71491
# Starting mysqld daemon with databases from /usr/local/var
030104 23:01:55  mysqld ended


[1]    Done                          /usr/local/bin/safe_mysqld
--user=mysql

How do I re-point mysql to look for my old database, I guess that's the
problem right?

Thank you Stefan

Best Regards, Anton


-----Original Message-----
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 04, 2003 2:14 PM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please

Anton,

>ps -ef | grep mysqld
>got nothing

Because the MySQL SERVER isn't running!

>Though I can do:
># mysql -u root -p

With this command, you start the MySQL Monitor (that's the SQL command
line CLIENT tool that comes along with MySQL) and tell it to connect to
a MySQL SERVER running on localhost, as user root and willing to enter a
password.

>Enter password:
>ERROR 2002: Can't connect to local MySQL server through socket
>'/tmp/mysql.sock' (61)

Can't connect - this means the CLIENT tool cannot connect because there
is no server running!

Start the server using the mysql_safe script (more info here:
http://www.mysql.com/doc/en/safe_mysqld.html).

For a test, you can simply start the server like this:

# mysqld &

AFTER THAT you connect to the SERVER using the CLIENT tool mysql.

Hope this gets you running,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

----- Original Message -----
From: "Anton Zavrin" <[EMAIL PROTECTED]>
To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas
Spahni'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 9:59 PM
Subject: RE: MySQL Help Needed Please


Did:
ps -ef | grep mysqld

got nothing
Though I can do:
# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
#

Anything else I should try :( ?

Best Regards, Anton


-----Original Message-----
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 8:01 AM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please

Anton,

first thing, try:

ps [whatever options] | grep mysqld

The daemon (database server) is called mysqld, not mysql.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

----- Original Message -----
From: "Anton Zavrin" <[EMAIL PROTECTED]>
To: "'Thomas Spahni'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 9:01 AM
Subject: RE: MySQL Help Needed Please


> I have this file:
> srwxrwxrwx  1 mysql  wheel    0 Jan  2 16:45 mysql.sock
>
> I have two of .err files and non of the log files
>
> I also can't find my *.cnf file(s)
>
> Did: ps -ef | grep mysql
> Got nothing
>
> What should I do?
>
> Best Regards, Anton
>
>
> -----Original Message-----
> From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 03, 2003 7:01 AM
> To: Anton Zavrin
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL Help Needed Please
>
> Anton,
>
> check the <hostname>.err and <hostname>.log files in your data
> directory.
> Then check permissions. My sock file looks like:
>
> srwxrwxrwx    1 mysql    daemon          0 Dez 30 19:12 mysql.sock
>
> and finally check for your
>
> socket                = /tmp/mysql.sock
>
> entries in /etc/my.cnf and ~/.my.cnf
>
> Thomas Spahni
>
> On Fri, 3 Jan 2003, Anton Zavrin wrote:
>
> > Hi guys,
> > I'm new here and need help.
> > I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL
> installed
> > but when I'm trying to run it says:
> > error: 'Can't connect to local MySQL server through socket
> > '/tmp/mysql.sock' (61)' Check that mysqld is running and that the
> > socket: '/tmp/mysql.sock' exists!
> >
> > I checked /tmp/mysql.sock' and the file exists.
> > But I don't see any process that would show me mysqld is running.
> >
> > Then I tried to re-install it from the ports and it says:
> > You appear to already have a mysql database directory in
> /var/db/mysql.
> >
> > In order to preserve your existing data, you should:
> >         - dump all your databases
> >         - kill mysql if it is running
> >         - delete the /var/db/mysql directory
> >         - run 'make install'
> >         - start up mysql
> >         - re-create all of your database
> >         - re-load your data
> >
> > If you understand the consequences of this upgrade, please re-build
> this
> > port with the environment variable OVERWRITE_DB defined.
> > *** Error code 1
> >
> > Stop in /usr/ports/databases/mysql323-server.
> >
> > Please help, what should I do?
> >
> > Best Regards, Anton
>
>
> ---------------------------------------------------------------------
> 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
>



---------------------------------------------------------------------
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


---------------------------------------------------------------------
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

Reply via email to