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