[mythtv-users] how to delete all senders?

[greg]

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?
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>   
  Depending how you set it up the backup may be in.  
/var/lib/mythtv/db_backups,

As for the channel editor,better to spend a hour with it, than trash 
your database and spend days trying to repair....Safe trumps quick in 
this instance...