[mythtv-users] recordedmarkup table corruption

[Kevin Kuphal]

Preet Khalsa wrote:

>I had a hard lockup on the backend.  Froze the entire machine.  My
>reiserfs file system recovered much, but left the table recordedmarkup
>corrupt.  This meant that nuvexport would not run and spits out ...
>
>Can't open file: 'recordedmarkup.MYD'. (errno: 145)
>
>I checked /var/lib/mysql/mythconverg and it is there.  So the table is
>corrupt.
>
>To fix this, log into mysql ...
>
>mysql -u root -p mythconverg
>
>and then check and repair the table ...
>
>check table recordedmarkup;
>repair table recordedmarkup;
>
>And then all should be well.
>
>I am posting this because google resulted in nothing useful.
>  
>
Google: mysql errno 145 site:mysql.com
Result #5: http://dev.mysql.com/doc/mysql/en/repair.html (How to Repair 
Tables)

Always good to remember that mythtv relies on the health of external 
programs and they often have excellent resources to diagnose problems 
with them

Kevin