[mythtv-users] [OT] Mysql database hosed after pwr loss.

[Jason]

Hi all,
 Sorry for the OT but my database seems to be hosed
(stupid power outage).
I was hoping someone would know a quick fix.  When I
start up mythbackend this is what I get:

Gentoo mythconverg # mythbackend -d
Gentoo mythconverg # Starting up as the master server.
2004-01-13 16:50:52 mythbackend version:
0.14.20040102-1 www.mythtv.org
2004-01-13 16:50:52 Enabled verbose msgs : important
general
DB Error (findAllProgramsToRecord):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid,
program.starttime, program.endtime, program.title,
program.subtitle, program.description,
channel.channum, channel.callsign, channel.name,
oldrecorded.starttime IS NOT NULL AS oldrecduplicate,
program.category, record.recpriority,
record.recorddups, recorded.starttime IS NOT NULL as
recduplicate, record.type, record.recordid,
recordoverride.type, program.starttime - INTERVAL
record.preroll minute, program.endtime + INTERVAL
record.postroll minute, program.previouslyshown FROM
record  INNER JOIN channel ON (channel.chanid =
program.chanid)  INNER JOIN program ON (program.title
= record.title)  LEFT JOIN oldrecorded ON   (    
oldrecorded.title IS NOT NULL AND oldrecorded.title <>
'' AND program.title = oldrecorded.title      AND    
oldrecorded.subtitle IS NOT NULL AND
oldrecorded.subtitle <> '' AND program.subtitle =
oldrecorded.subtitle      AND    
oldrecorded.description IS NOT NULL AND
oldrecorded.description <> '' AND program.description
= oldrecorded.description  )  LEFT JOIN recorded ON  
(     recorded.title IS NOT NULL AND recorded.title <>
'' AND program.title = recorded.title      AND    
recorded.subtitle IS NOT NULL AND recorded.subtitle <>
'' AND program.subtitle = recorded.subtitle      AND  
  recorded.description IS NOT NULL AND
recorded.description <> '' AND program.description =
recorded.description  )  LEFT JOIN recordoverride ON  
(     record.recordid = recordoverride.recordid    
AND program.chanid = recordoverride.chanid     AND
program.starttime = recordoverride.starttime     AND
program.endtime = recordoverride.endtime     AND
program.title = recordoverride.title     AND
program.subtitle = recordoverride.subtitle     AND
program.description = recordoverride.description   )
WHERE ((record.type = 4)  OR  ((record.chanid =
program.chanid)   AND   ((record.type = 3)    OR  
((TIME_TO_SEC(record.starttime) =
TIME_TO_SEC(program.starttime))     AND    
((record.type = 2)      OR    
((DAYOFWEEK(record.startdate) =
DAYOFWEEK(program.starttime)       AND      
((record.type = 5)        OR      
((TO_DAYS(record.startdate) =
TO_DAYS(program.starttime))         AND        
(TIME_TO_SEC(record.endtime) =
TIME_TO_SEC(program.endtime))         AND        
(TO_DAYS(record.enddate) = TO_DAYS(program.endtime))  
      )       )      )     )    )   )  ) ));
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'recorded.MYI'. (errno: 145)

2004-01-13 16:50:54 Found changes in the todo list.

Gentoo mythconverg # pwd
/var/lib/mysql/mythconverg
Gentoo mythconverg # ls -alh recorded.MYI
-rw-rw----    1 mysql    mysql        3.0K Jan 12 22:00 recorded.MYI

Live tv works, nothing shows up in the watch/delete
recordings and none of my to be recorded programs are
listed.  Thanks for any help.