Date: Wed, 20 Apr 2005 14:59:58 +0200 From: Kees Plonsz <spam@jeremino.homeunix.net> To: freebsd-questions@freebsd.org Subject: Re: MySQL Server died yesterday ! Message-ID: <9441475.zdZqayOQ8n@not_a_message_id> References: <list.freebsd.questions#20050420032237.3CA7616A4EE@hub.freebsd.org> <list.freebsd.questions#20050420114936.GA94042@kongemord.krig.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?9441475.zdZqayOQ8n>