[mythtv-users] Problem with "Jump Ahead" feature - KnoppMyth R4V4

[Isaac Richards]

On Wednesday 04 August 2004 07:22 pm, Blammo[doh] wrote:
> mysql> REPAIR TABLE recordedmarkup
>     -> ;
> +----------------------------+--------+----------+----------+
>
> | Table                      | Op     | Msg_type | Msg_text |
>
> +----------------------------+--------+----------+----------+
>
> | mythconverg.recordedmarkup | repair | status   | OK       |
>
> +----------------------------+--------+----------+----------+
> 1 row in set (0.32 sec)
>
>
> Didn't appear to have any effect. However I did change to the
> /var/lib/mysql/mythconverg directory, and check the tables. It did find
> tables needing repair, so I did:
>
> myisamchk -r *.MYI
>
> While it repaired the tables, even after rebooting NFS / backend /
> frontend, I still have the same problem on the frontend. The backend still
> works "instantly"

If the DB had been broken for a while, you'd need to run 'mythcommflag' on 
your recordings to regenerate the seek tables.

Isaac