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

[Michael Haan]

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

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

[Rudy Zijlstra]

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

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

[Marc Tousignant]

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