[mythtv-users] MySql Error - Error Clearing Recorded Markup?

Marc Tousignant drayson at net1plus.com
Fri Jul 8 20:11:06 EDT 2005


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: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] 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



More information about the mythtv-users mailing list