Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 8 Aug 2006 16:13:24 +0200 (CEST)
From:      Oliver Fromme <olli@lurza.secnetix.de>
To:        freebsd-database@FreeBSD.ORG
Subject:   Re: mysql.sock deleted
Message-ID:  <200608081413.k78EDOV1010792@lurza.secnetix.de>
In-Reply-To: <freebsd-database.235b80000607200452l41a3962vcbd94fc2503b05f4@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200608081413.k78EDOV1010792>