From owner-freebsd-database@FreeBSD.ORG Tue Aug 8 14:13:34 2006 Return-Path: X-Original-To: freebsd-database@FreeBSD.ORG Delivered-To: freebsd-database@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A893216A4DD for ; Tue, 8 Aug 2006 14:13:34 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8]) by mx1.FreeBSD.org (Postfix) with ESMTP id B84C643D77 for ; Tue, 8 Aug 2006 14:13:31 +0000 (GMT) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (opipkn@localhost [127.0.0.1]) by lurza.secnetix.de (8.13.4/8.13.4) with ESMTP id k78EDOqo010793 for ; Tue, 8 Aug 2006 16:13:29 +0200 (CEST) (envelope-from oliver.fromme@secnetix.de) Received: (from olli@localhost) by lurza.secnetix.de (8.13.4/8.13.1/Submit) id k78EDOV1010792; Tue, 8 Aug 2006 16:13:24 +0200 (CEST) (envelope-from olli) Date: Tue, 8 Aug 2006 16:13:24 +0200 (CEST) Message-Id: <200608081413.k78EDOV1010792@lurza.secnetix.de> From: Oliver Fromme To: freebsd-database@FreeBSD.ORG In-Reply-To: X-Newsgroups: list.freebsd-database User-Agent: tin/1.8.0-20051224 ("Ronay") (UNIX) (FreeBSD/4.11-STABLE (i386)) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.1.2 (lurza.secnetix.de [127.0.0.1]); Tue, 08 Aug 2006 16:13:29 +0200 (CEST) Cc: Subject: Re: mysql.sock deleted X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd-database@FreeBSD.ORG List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Aug 2006 14:13:34 -0000 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