opqdan
Guru
Joined: 13 Dec 2004
Posts: 429
Location: Redmond, WA, USA
|
 Posted: Wed May 10, 2006 7:31 pm Post subject: MythTV recordings table rebuild and clean[nevermind, solved] |
 |
|
**EDIT: Ok, I am an idiot. This has to be a record for shortest post-to-solution ever. It needs to keep track of the old recordings so that it knows to skip them in the future, and the simple way of telling mythcommflag to only do recent ones was with --allstart=YYYYMMDDHHMMSS. I don't think that posts can be deleted, so this one can stand as a monument to RTFM.
Last week I was running some network protocol simulations for my senior project and ended up filling the root partition of my MythTV box (there is a long story explaining why I was running my project simulations on my media center, and why they produced 13Gb of results...). Anyways, the whole computer crapped out and I had to boot with a boot disk and clear out the files. It seems that somewhere along the way, a couple of tables were screwed up in the mythconverg database, including the one that includes seeking information for recordings.
After a little bit of work I managed to rescue the tables (mysqlrepair -A), but I need to rebuild seek information for a couple of files. To do so, I would normally use the line:
| Code: | | mythcommflag --rebuild --all |
The problem is that it seems that the database includes an entry for everything that was ever recorded, all the way back to January and including the recordings from LiveTV that have expired since then. When I run the above command, it goes though each of these files and tries them 10 times or so before giving up. This will take forever, and still does not clear out the non-existant entries. Is there a simple method of removing recordings with non-existant files from the database? |
|
Multimedia
