<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Curtis Porter wrote:
<blockquote cite="mid:4ADFD6FB.7040303@gmail.com" type="cite">
<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">
<blockquote
cite="mid:a6ecfbaa0910202120w1857f0d1qb2e98690b913028b@mail.gmail.com"
type="cite">
<pre wrap="">
I don't think you need to mess with your database directly. You can
just delete the affected recordings with the "delete and allow
rerecord". I had the same problem a while back. There were some issues
to do it with a whole bunch of recordings using a playlist, but it
worked well. Read through this thread to see how I worked it out and
for suggestions that others gave:
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.gossamer-threads.com/lists/mythtv/users/374203">http://www.gossamer-threads.com/lists/mythtv/users/374203</a>.</pre>
</blockquote>
Thanks for the suggestions! I was rather hoping to avoid manually
deleting the files since there are 321 recorded programs in the
database, which would take a long time to go through via the regular
UI. I'm not very familiar with the playlist functionality, do you
recall roughly what you had to do to make that work?<br>
<br>
Thanks,<br>
Curtis<br>
</blockquote>
Nevermind, I figured it out -- it's not bad at all. In case it can
help someone else:<br>
Go to the "Watch Recordings" screen, highlight "All Programs", hit "m"
for the menu, and choose "Add to playlist". Then hit "m" again and
choose "Playlist options" and then "Delete and Re-Record". You just
have to touched all the files first so it will delete successfully. I
did that with the following script (modified from a posting by
kfitzpatrick):<br>
<br>
#!/bin/bash<br>
#<br>
RECORDINGDIR="/mnt/mythtv/store"<br>
MYSQLUSER="mythtv"<br>
MYSQLPASS="mythtv"<br>
#<br>
# Create a list of filenames from the database<br>
#<br>
for filename in `mysql -u $MYSQLUSER -p$MYSQLPASS --batch -e "SELECT<br>
basename FROM recorded ORDER BY basename" mythconverg`<br>
do<br>
echo "record is $RECORDINGDIR/$filename"<br>
touch "$RECORDINGDIR/$filename"<br>
done<br>
<br>
<br>
Thanks again!<br>
</body>
</html>