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

[Jason]

Sorry about that, I figured it out. A simple
mysqlcheck-r mythconverg 
fixed the problem.

----- Original Message ----- 
Subject: [mythtv-users] [OT] Mysql database hosed after pwr loss.


> 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.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users