MySQL Server died yesterday !

[Kees Plonsz]

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