On Wed, 06 Nov 2002 11:23:30 +0200 Tuomas Järvinen <[EMAIL PROTECTED]> wrote:
> > 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) > perror 145 145 = Table was marked as crashed and should be repaired Reapir the table with myisamchk > 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 > -- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- 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