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

Andreas Bach Aaen usenet at bachaaen.dk
Sat Apr 26 19:16:24 UTC 2008


L๘rdag den 26. April 2008 skrev Mache Creeger:
 > >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?
> # find / -name myth.rebuilddatabase.pl
> # ~/myth.rebuilddatabase.pl

Seems a good idea.
I did a: "repair table recorded;" within mysql. It worked. Now I 
simply want to check if other less often used tables has the same 
problem.

> or if that does not work delete the mythconverg
> database from mysql and reload from one of your frequently made
> backups.
Real men don't make backups they cry. Well I do have a 6 day old 
database backup if I end up doing something stupid.

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


More information about the mythtv-users mailing list