Mysql does not start, what can I do?

[Tuomas Järvinen]

Hello!
I was few days avay from my office, and when I came back today, I got some emails, nobody can't connect to database server. When I tried to restart mysqld (3.23.46, debian (woody) initscript failed. Manually starting the server say:

021106 10:24:12 mysqld: Can't open file: 'user.MYD'. (errno: 145)

Datadir value in /etc/mysql/my.cnf points to /var/lib/mysql.

user & group rights should be Okay:

#ls -l /var/lib/

drwxr-xr-x 9 mysql mysql 4096 loka 11 09:51 mysql


#ls -l /var/lib/mysql/mysql

-rw-rw---- 1 mysql mysql 9148 syys 6 13:00 user.frm
-rw-rw---- 1 mysql mysql 4096 marras 1 09:11 user.MYD
-rw-rw---- 1 mysql mysql 2048 marras 1 09:11 user.MYI

If someone can help me, Thanks.




--
---------------------------------------------------------------
Espoon Liiketalousinstituutti - Espoo institute of business
ATK-tuki - Helpdesk
Tuomas Järvinen

Mail address Karapellontie 11
ZIp & City 02610 ESPOO FINLAND
mobile: +358 (0)50 5287522
E-mail: [EMAIL PROTECTED]
WWW: http://www.elit.eskk.fi




---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php