[mythtv-users] Cleaning up orphan database records

Astie, Sebastien sastie at us.nomura.com
Thu Apr 19 16:40:59 UTC 2007


I had the same issue.

I wanted to delete all my items in the LiveTV group.
In order to do so, you can login in MySQL and do 
DELETE from record where group = 'LiveTV';

If I remember correctly that this is the appropriate table and column
name.
Just double check by doing a select on the the table before doing
anything.



-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Bob Sully
Sent: Thursday, April 19, 2007 12:37 PM
To: mythtv-users at mythtv.org
Subject: [mythtv-users] Cleaning up orphan database records

Quick question -

I have about 35 records in the database pointing to old LiveTV
recordings
that no longer exist on disk.  I don't know how this happened, but I'd
like to clean them up.  Trying to delete them through MythWeb is
ineffective - this shows up in the backend logs, and the entry doesn't
get
deleted from the database:


File /mythtv/recordings/3214_20070213220901.nuv does not exist for
chanid
3214 at Tue Feb 13 22:09:01 2007 when trying to delete recording.


Are there any utilities within Myth which will clean up the DB, or do I
have to figure out how to do it using MySQL commands?

Thanks...Bob
-- 
________________________________________
Bob Sully - Simi Valley, California, USA
http://www.malibyte.net
http://www.malibyte.com

_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


Notice for Sales & Trading Communication

The information, tools and material presented in this email have been prepared by individual Sales and/or Trading personnel of Nomura Securities, International, Inc. ("Nomura"). References to Nomura research reports should be read in conjunction with the full text of the actual report. Please access the following link for important related information and instructions for accessing Nomura Research reports.

Http://www.nomura.com/americas/NoticeforSalesandTrading.html

This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please delete it and all copies from your system, destroy any hard copies and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Nomura Holding America Inc., Nomura Securities International, Inc, and their respective subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state the views of such entity. Unless otherwise stated, any pricing information in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation.Notice for Sales & Trading Communication.


More information about the mythtv-users mailing list