Efter ett strömavbrott så vill inte min MySQL databas fungera(!) alla tabeller funkar utan den viktigaste (givetvis) tabellen members. När jag ga går till en ASP sida som kontaktar members så får man detta felmeddelandet:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't open file: 'members.MYI'. (errno: 144)
/logga_in.asp, line 38
Rad 38
Set Rs = Connect.Execute("SELECT username,datum,inloggad,bakgr FROM members where username='"& secure(vem) &"' and losen = '"& secure(request.form("losen")) &"' LIMIT 1")
När jag försöker gå in i tabellen members i MySQL Control Center 0.9.4 så får jag detta felmeddelande:
[root@localhost:3306] ERROR 1016: Can't open file: 'members.MYI'. (errno: 144)
Och när jag försöker reparera den så får jag dessa:
# [root@jobb:3306] Query Window
# Connection: root@jobb:3306
# Host: 192.168.0.107
# Saved: 2004-10-24 18:20:24
#
# Query:
# REPAIR TABLE
# `members`
#
'Table','Op','Msg_type','Msg_text'
'nojet','repair','info','Found block with too small length at 152832; Skipped'
'nojet','repair','info','Found block with too small length at 152876; Skipped'
'nojet','repair','info','Found block with too small length at 152896; Skipped'
'nojet','repair','info','Found block with too small length at 153384; Skipped'
'nojet','repair','info','Key 1 - Found wrong stored record at 1268068'
'nojet','repair','info','Found block that points outside data file at 1268128'
'nojet','repair','info','Found block with too small length at 1700328; Skipped'
'nojet','repair','error','Not enough memory for blob at 1700448 (need 1918986603)'
'nojet','repair','info','Found block with too small length at 152832; Skipped'
'nojet','repair','info','Found block with too small length at 152876; Skipped'
'nojet','repair','info','Found block with too small length at 152896; Skipped'
'nojet','repair','info','Found block with too small length at 153384; Skipped'
'nojet','repair','info','Key 1 - Found wrong stored record at 1268068'
'nojet','repair','info','Found block that points outside data file at 1268128'
'nojet','repair','info','Found block with too small length at 1700328; Skipped'
'nojet','repair','error','Not enough memory for blob at 1700448 (need 1918986603)'
'nojet','repair','status','Operation failed'
Någon som vet hur jag kan reparera/få igång den igen skulle vara evigt tacksam eftersom jag inte har tagit någon backup på flera dagar. :(
//RED
Har testat alla steg här