[mythtv-users] recordedmarkup table corruption
Kevin Kuphal
kuphal at dls.net
Thu Apr 28 23:26:12 UTC 2005
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
More information about the mythtv-users
mailing list