Alternately you can run mysqlrepair -umythtv -pmythtv mythconverg to check all tables and mysqlrepair -umythtv -pmythtv -r mythconverg to repair all tables
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:mythtv-users- > [EMAIL PROTECTED] On Behalf Of Rudy Zijlstra > Sent: Friday, July 08, 2005 12:24 PM > To: Michael Haan; Discussion about mythtv > Subject: Re: [mythtv-users] MySql Error - Error Clearing Recorded Markup? > > Michael Haan wrote: > > >I just rebooted my Myth box, which was working fine, and I get this > >now when trying to start mythbackend: > > > >DB Error (Clear markup on record): > >Query was: > >DELETE FROM recordedmarkup WHERE chanid = '1013' AND starttime = > >'20050708115700'; > >Driver error was [2/1016]: > >QMYSQL3: Unable to execute query > >Database error was: > >Can't open file: 'recordedmarkup.MYI'. (errno: 145) > > > >Any ideas what this is and how to fix it? > >_______________________________________________ > > > > > Yes. > > Table corruption. when in mysql give the commnd "check table > recordedmarkup", likely followed by "repair table recordedmarkup". > > Cheers
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users