[mythtv-users] MySQL help w/deleting a row[entry]
Michael T. Dean
mtdean at thirdcontact.com
Wed Nov 25 19:45:53 UTC 2009
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.
More information about the mythtv-users