[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