[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