[mythtv-users] How to reset in video manager the list of all genre/category etc...

[Ma Begaj]

2009/2/6 Jean-Yves Avenard <jyavenard at gmail.com>:
> Hi
>
> 2009/2/6 Ma Begaj <derliebegott at gmail.com>:
>> you could "chmod 000 /your/mythvideo/folder" and than refresh
>> mythvideo database from the menu. it will ask you to delete all
>> entries... that should delete everything ...
>
> It deletes the data for all entries, but the various categories and
> genres aren't reset.
>
> I previously incorrectly filled categories and I want to remove those entries...
>
>>
>> you should have to delete covers by hand I think...
> that's easily done...

Than open mysql in phpMyAdmin or directly on the shell "mysql -umythtv
-pmythtv mythconverg" and check out the mythvideo* tables or something
like that.

I have a cronjob which put files from certain folders in certain
categories once a day... everything in folder /mnt/private is being
"put" in the category "private" with something like this:
echo 'UPDATE mythvideo.... SET category = 1 WHERE filename LIKE
'/mnt/private/%' | mysql -umythtv -pmythtv mythconverg

I dont think that you can break it as you seem to know enough about
programming and software. But making backup cannot harm