[mythtv-users] Corrupted database file

[IvanK.]

log into mysql and issue this command for every corrupted table:

REPAIR TABLE <table>;

that did it for me when two of my tables got corrupted a few days ago.

After that do CHECK TABLE <table>;

Keep in mind that no program should be using the db while you're repairing 
tables.  It's best to stop mythbackend, and everything else that *might* be 
trying to open mysql sessions.

IvanK.

On Monday 23 August 2004 10:38 am, Adam Felson wrote:
> I'm getting tons of the following error in my logs:
>         2004-08-23 08:09:49 MainServer::HandleAnnounce Playback
>         2004-08-23 08:09:49 adding: myth as a client (events: 0)
>         DB Error (Recorded program deletion (2)):
>         Query was:
>         DELETE FROM recordedmarkup WHERE chanid = 1002 AND starttime =
>         20040822202400;
>         Driver error was [2/-1]:
>         QMYSQL3: Unable to execute query
>         Database error was:
>         Can't open file: 'recordedmarkup.MYI'. (errno: 145)
> It looks like a table got corrupted.
> Can somebody give me a clue how to repair it?