[mythtv-users] MySQL help w/deleting a row[entry]

[Michael T. Dean]

On 11/25/2009 02:41 PM, Bobby Gill wrote:
> Have been googling and found the MySQL reference manual as well as 
> some blogs, but out of sheer fear for accidentally deleting the wrong 
> thing(s) (if not my entire database lol, though I do have it backed up 
> nightly), just wondering how I can remove this entry:
>
> mysql> select * from recorded where starttime IS NULL;
...
> It's a .avi file that I added to the recordings directory but I kinda 
> fudged up on entering myth.rebuilddatabase.pl 
> <http://myth.rebuilddatabase.pl> info (starttime, chanid, etc.) and I 
> would like to remove it completely anyhow. Everytime I delete from the 
> FE, it shows up again, can't get rid of it...

Fix the permissions on the file/directory so that the mythbackend user 
has permission to delete it, then use the frontend to delete it.

If that's not it, at least do:

UPDATE recorded SET starttime = NOW() WHERE starttime IS NULL;

Then use the frontend to delete it.

Mike