[mythtv-users] Mythvideo categories

Jack McGee jack at greendesk.net
Mon Aug 10 23:56:58 UTC 2015


On 08/10/2015 01:33 PM, Paul Harrison wrote:
> On 10/08/15 19:03, Jack McGee wrote:
>>
>> Thanks, I tried to install phpmyadmin but that is not working 
>> correctly, and rather than track that down also, does anyone have a 
>> mysql command I can use to delete categories?
>> I am certain no videos are using the categories I want to delete.
>>
>
> To delete the 'Test' category :-
> DELETE FROM videocategory WHERE category = 'Test';
>
> To see what categories are defined :-
> SELECT * FROM videocategory;
>
> To see if category 'Test' is referenced by videometadata :
> SELECT title FROM videometadata LEFT JOIN videocategory ON 
> videometadata.category = videocategory.intid WHERE 
> videocategory.category = 'Test';
>


Much thanks Paul.  I did that and after restart of frontend, categories 
I deleted were gone!


More information about the mythtv-users mailing list