Because recorded TV programs did not FF/REW properly or skip commercials, I repaired the MySQL tables per http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043&highlight=tables using:


The repair seemed to work OK, so I rebuilt the commercial seek table using



That also ran without error, so I rebooted. However, after rebooting, the list of my recordings was blank. I rebooted again.

This time, after displaying the MythTV boot screen and progress bar, the MythTV logo screen appeared and stayed on the screen; MythTV did not start.

I'll appreciate any suggestions to fix these problems. (I'm a Linux novice and appreciate drunken monkey advice.)

R5F27
AMD64 4200+ 2.2 Ghz processor
1GB memory
Leadtek GF PX 6200 video card
2 Airstream HD-5000 tuner cards
WD 500GB HD

If you did a backup first, you may want to restore it and try the repair again. Are you still using R5F27 as your signature shows? I don't have much experience on that end, but I thought this might luck out and get up and running quickly this way.

Thanks, knappster, for your reply. I am using R5F27 and did not make a backup.

I decided to again repair the MySQL tables using the instructions at http://www.knoppmythwiki.org/index.php?page=RepairingMythConvergDB

I found and repaired an additional 12 tables that were corrupt. Then, I restarted MySQL and the Myth backend:



And, finally, I right-clicked on the MythTV logo screen and restarted MythTV.

My recorded program once again show up when I select Watch Recordings and play properly.

Well that's good to hear jb3. It looks like the two methods were pretty much the same. Any idea why it worked the 2nd time but not the first?

Good question. Haste makes waste?

Initially, I tried to repair the tables using the wildcard that looked to me like it should repair all the tables at once. I did not run
to see what specific files were corrupt.

The second time, I followed the step-by-step suggestions at http://www.knoppmythwiki.org/index.php?page=RepairingMythConvergDB, specifically,

I then repaired each crashed file one at a time using myisamchk -r crashedfilename.MYI.

I re-ran myisamchk to make sure all file had been repaired, then ran mythcommflg to rebuild the seek tables.

Now, the REW/FF and SKIP AHEAD/BACK functions work fine, but the commercials weren't flagged in the several older recordings I checked. Commercials were flagged in programs recorded after I repaired the tables. I recall reading that mythcommflag only uses blank frame detection and perhaps that is not strong enough. In any case, I am declaring victory and moving on.

_________________
R5F27
AMD64 4200+ 2.2 Ghz processor
1GB memory
Leadtek GF PX 6200 video card
2 Airstream HD-5000 tuner cards
WD 500GB HD

Alright, thanks for the information. Hopefully that will be helpful to somebody in the future.

I know I often find myself going back to my own posts to redo something that I did before and had forgotten about.

FF/REW and seek were still not working properly and program length was incorrect, but this did the trick:

I transcoded each file individually, but it only takes a few minutes. I tried using *.filename, but that did not work.

_________________
R5F27
AMD64 4200+ 2.2 Ghz processor
1GB memory
Leadtek GF PX 6200 video card
2 Airstream HD-5000 tuner cards
WD 500GB HD