[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