[mythtv-users] need help with mysql database after crash and loss of 'recordedmarkup' table

[anders smith]

Thanks Chris,
I'll try " REPAIR TABLE recordedmarkup" tonight.

I'm not actually using commercial skipping so it's not a great issue 
for me. I just thought that I had something to do with my missing 
recordings...

Do you have any idea why mythtv couldn't find the recordings after I 
changed the location in KDE, but could when I reset it to the original 
location?

I would have imagined that the filename that myth uses in mysql, to 
link metadata to actual movie file wouldn't change...?

Any thoughts?

On May 3, 2004, at 11:30 PM, Chris Petersen wrote:

>> What is in the 'recordedmarkup' mysql table?
>
> The commercial flag info (not the cutlist).  You can wipe it out and
> just run mythcommflag and get your info back.
>
> You should also try:  REPAIR TABLE recordedmarkup;
>
> Not sure if that was suggested, but mysql is pretty good about
> recovering corrupted tables (since it's often only the index that gets
> corrupted).
>
> -Chris
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>