[mythtv-users] All my recording simply vanished! - database crashed!

[Andreas Bach Aaen]

Hi,

I am using mythtv 0.21.
A am using both the official client and mvpmc as a client against the 
backend server.

Yesterday my mythtv backend server crashed. I can still se all the 
files that I hve recorded the last years in /var/lib/mythtv but the 
frontend can't see any recordings. It seem that my database crashed.

mysql> select * from recorded;
ERROR 145 (HY000): Table './mythconverg/recorded' is marked as crashed 
and should be repaired

Possible more tables are affected.
How can I recover this?

Regards,
-- 
 /\ ,_  _|,_ _  _  _,  |¨) _  _ |_    /\  _  _ ,_
/¨¨\| )(_|| (-'.-|`-,  |¨).-|(_ | )  /¨¨\.-|(-'| )
¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨
Open Source og Linux:  http://www.bachaaen.dk/blog