[mythtv-users] No seektable

[Michael T. Dean]

On 12/10/2007 02:55 PM, Milos Prudek wrote:
> when I want to edit recordings I get "No seektable" message. I googled. I am 
> not the first to have this problem. I tried one of the solutions that I found 
> via Google:
>
> /etc/init.d/mythtv-backend stop
> mysqlcheck -r -u mythtv -p mythconverg
> /etc/init.d/mythtv-backend start
>
> the above command should check for errors. No errors were shown. All tables 
> were reported as "OK". Important: table mythconverg.recordedseek was NOT 
> reported at all! 
>
> Then I tried mythcommflag --rebuild -f 1066_20071207153000.mpg and I got this 
> error:
>
> MYSQL3: Unable to execute query
> Database error was:
> Table './mythconverg/recordedseek' is marked as crashed and should be repaired
>
> How can I fix it? I know how to work on command line but I know nothing about 
> mysql (I know postgresql).

Use optimize_mythdb.pl.  It works properly whereas the wrong incantation
of arguments for mysqlcheck does not.

Mike