From owner-freebsd-questions@FreeBSD.ORG Wed Apr 20 13:00:05 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D115F16A4CE for ; Wed, 20 Apr 2005 13:00:05 +0000 (GMT) Received: from jeremino.homeunix.net (jeremino.xs4all.nl [80.126.224.163]) by mx1.FreeBSD.org (Postfix) with ESMTP id C281F43D5D for ; Wed, 20 Apr 2005 13:00:04 +0000 (GMT) (envelope-from spam@jeremino.homeunix.net) Received: from jeremina.homeunix.net ([10.0.0.5]) by jeremino.homeunix.net with smtp (Exim 4.42) id 1DOEoD-000Am0-LH for freebsd-questions@freebsd.org; Wed, 20 Apr 2005 15:00:02 +0200 Message-Id: <9441475.zdZqayOQ8n@not_a_message_id> From: Kees Plonsz To: freebsd-questions@freebsd.org Date: Wed, 20 Apr 2005 14:59:58 +0200 References: Lines: 46 Organization: Chaos User-Agent: KNode/0.8.0 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Subject: Re: MySQL Server died yesterday ! X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Apr 2005 13:00:05 -0000 Bob Hall wrote on Wednesday 20 April 2005 13:49 in the group list.freebsd.questions: > This is a very MySQL specific question. You should post it to the MySQL > mailing list. > > It's been a while since I used MySQL. The host table is in the MySQL > database. There should be a directory called data, or something similar, > and inside that there is a directory called mysql, and inside that there > is a file called host, which contains the host table. Or at least, > that's what I remember. Either that file is missing, or the system > permissions on it have changed, or MySQL has changed access privileges > on it. Or something. Check to make sure that it is there, and has the > correct system permissions (ls -l). If it's not there, you may have to > back up all your tables and reinstall. Or you may be able to reinstall > just the host table. Further questions should go to a MySQL mailing > list. > > Bob Hall The only host file I can find is in "/var/db/mysql/mysq" -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 columns_priv.MYI -rw-rw---- 1 mysql mysql 8778 Nov 19 09:12 columns_priv.frm -rw-rw---- 1 mysql mysql 765 Dec 5 07:55 db.MYD -rw-rw---- 1 mysql mysql 3072 Dec 6 09:32 db.MYI -rw-rw---- 1 mysql mysql 9088 Nov 19 09:12 db.frm -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 func.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 func.MYI -rw-rw---- 1 mysql mysql 8641 Nov 19 09:12 func.frm -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 host.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 host.MYI -rw-rw---- 1 mysql mysql 9064 Nov 19 09:12 host.frm -rw-rw---- 1 mysql mysql 0 Nov 19 09:12 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 Nov 19 09:12 tables_priv.MYI -rw-rw---- 1 mysql mysql 8877 Nov 19 09:12 tables_priv.frm -rw-rw---- 1 mysql mysql 404 Dec 5 07:55 user.MYD -rw-rw---- 1 mysql mysql 2048 Dec 6 09:32 user.MYI -rw-rw---- 1 mysql mysql 9806 Nov 19 09:12 user.frm -- Key-ID = A6581435 E-mail address is valid