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

[Mache Creeger]

At 11:48 AM 4/26/2008, Andreas Bach Aaen wrote:
>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

# find / -name myth.rebuilddatabase.pl
# ~/myth.rebuilddatabase.pl

or if that does not work delete the mythconverg 
database from mysql and reload from one of your frequently made backups.

-- Mache

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080426/495e036e/attachment.htm