mysql.sock deleted

[Oliver Fromme]

I'm aware that this question is already a few weeks old,
but nobody has answered so far, so I'll give it a try,
so there's at least something in the archives ...

tethys ocean wrote:
 > While  doing
 > 
 > portupgrade -vr mysql
 > 
 > I lost my mysql socket . So mysql cant start.
 > How I can create mysql.sock

You cannot create a UNIX domain socket "manually".  It
is created automatically by the server process when it
performs the bind(2) system call.  There is no userland
tool to create a UNIX domain socket, because it wouldn't
make sense.

So the answer to your question is:  Just start the mysqld
server, and it will create the socket.

Best regards
   Oliver

PS:  How to create various types of files:

type             userland   syscall/libc
-------------------------------------------
plain files:     touch(1)   open(2)
directories:     mkdir(1)   mkdir(2)
symbolic links:  ln(1)      symlink(2)
device nodes:    mknod(8)   mknod(2)   (obsoleted by devfs)
named pipes:     mkfifo(1)  mkfifo(2)
whiteouts:       rm(1)      unlink(2)  (only on unionfs)
UNIX sockets:    --         bind(2)

Other operating systems might support additional types,
e.g. Solaris has a file type called "doors".

-- 
Oliver Fromme,  secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing
Dienstleistungen mit Schwerpunkt FreeBSD: http://www.secnetix.de/bsd
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"And believe me, as a C++ programmer, I don't hesitate to question
the decisions of language designers.  After a decent amount of C++
exposure, Python's flaws seem ridiculously small." -- Ville Vainio