[mythtv-users] how to delete all senders?

Mike Perkins mikep at randomtraveller.org.uk
Sun Dec 13 15:22:30 UTC 2009


lee wrote:
> On Sat, Dec 12, 2009 at 08:02:25PM -0500, greg wrote:
>> lee wrote:
>>> delete from channel where name="";
>>>
>> When you first installed mythtv it should have made a back up of the
>> database...See if you have that Back up available.. If so, use the
>> back up and restore scripts:
>>
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore
> 
> Hm, if I have a backup, I don't know where it is.
> 
>> The next time you want to get rid of the unknowns use the channel
>> editor, it takes longer,but you won't corrupt your database..
> 
> There are too many channels to do it manually. Is there some
> documentation about the database design?
> 
> It seems to work fine so far, and some dead data in the database won't
> really matter. But it bothers me ... and it could cause problems after
> some time which then would be hard to solve.
> 
> What if I just delete all tables or the whole database? Will it/they
> be recreated when running mythtv-setup?
> 
You could always use Mythweb. If you go to the channel editor in there, you can 
check 'delete' on as many channels as you wish, and then do them all at one go.

-- 

Mike Perkins



More information about the mythtv-users mailing list