[mythtv-users] recordedmarkup.MYI SQL Errors

[Gary Huntress]

MySQL error 145 is a crashed table.

log into mysql:

bash> mysql -p mythconverg

then repair the table:

mysql> repair table recordedmarkup;

that should do it
(reference
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#REPAIR_TABLE )

Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org


----- Original Message -----
From: <DBakker at arrayasolutions.com>
To: <mythtv-users at mythtv.org>
Sent: Monday, December 15, 2003 10:25 PM
Subject: [mythtv-users] recordedmarkup.MYI SQL Errors


> I keep getting these errors in my mythbackend log
>
> DB Error (position map insert):
> Query was:
> INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) values
> ( '1295', '20031215103000', 3572, 6, "897613862");
> Driver error was [2/1016]:
> QMYSQL3: Unable to execute query
> Database error was:
> Can't open file: 'recordedmarkup.MYI'. (errno: 145)
>
> any ideas?
>
>


----------------------------------------------------------------------------
----


_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users