<html>
<body>
<font size=3>At 11:48 AM 4/26/2008, Andreas Bach Aaen wrote:<br>
<blockquote type=cite class=cite cite="">Hi,<br><br>
I am using mythtv 0.21.<br>
A am using both the official client and mvpmc as a client against the
<br>
backend server.<br><br>
Yesterday my mythtv backend server crashed. I can still se all the <br>
files that I hve recorded the last years in /var/lib/mythtv but the <br>
frontend can't see any recordings. It seem that my database
crashed.<br><br>
mysql> select * from recorded;<br>
ERROR 145 (HY000): Table './mythconverg/recorded' is marked as crashed
<br>
and should be repaired<br><br>
Possible more tables are affected.<br>
How can I recover this?<br><br>
Regards,<br>
-- <br>
/\ ,_ _|,_ _ _ _, |จ) _ _
|_ /\ _ _ ,_<br>
/จจ\| )(_|| (-'.-|`-, |จ).-|(_ | ) /จจ\.-|(-'| )<br>
จจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจจ<br>
Open Source og Linux:
<a href="http://www.bachaaen.dk/blog" eudora="autourl">
http://www.bachaaen.dk/blog</a></font></blockquote><br>
# find / -name myth.rebuilddatabase.pl<br>
# ~/myth.rebuilddatabase.pl<br><br>
or if that does not work delete the mythconverg database from mysql and
reload from one of your frequently made backups. <br><br>
-- Mache<br><br>
</body>
</html>