Deleted sock file, how can I recover

2006-03-03 Thread Scott Haneda
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' 

I accidentally deleted the above file, I can not connect any new connections
in the CLI, old stuff seems to still be ok.

I can not seem to shut down the server, as that file is needed.

Any way I can recreate it, and what do I put in it?

I can force kill the server and I am guessing it would all come back up ok,
but there must be a gentler way?
-- 
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Novato, CA U.S.A.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Deleted sock file, how can I recover

2006-03-03 Thread Ryan Stille
Shut it down with mysqladmin, from another machine using the -h (host)
option.  

When you are using the CLI locally it connects through the socket, but
if you do it from another machine it will use TCP, getting around the
need for the missing socket file.

You may also be able to connect via TCP from the local machine,
depending on what address you use to connect to. (local IP, local host,
actual hostname, etc).  

-Ryan


Scott Haneda wrote:
 ERROR 2002: Can't connect to local MySQL server through
 socket '/tmp/mysql.sock'
 
 I accidentally deleted the above file, I can not connect any
 new connections in the CLI, old stuff seems to still be ok.
 
 I can not seem to shut down the server, as that file is needed.
 
 Any way I can recreate it, and what do I put in it?
 
 I can force kill the server and I am guessing it would all
 come back up ok, but there must be a gentler way?
 --
 -
 Scott HanedaTel: 415.898.2602
 http://www.newgeo.com Novato, CA U.S.A.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]