[mythtv-users] Deleting Recording Profile
David
myth at dgreaves.com
Wed May 26 03:59:12 EDT 2004
Richard Baker wrote:
>Hi,
>
>I created a "custom" recording profile I no longer
>wanted listed.
>
>How do I delete it?
>
>
Manually in 0.14 (I use mysqlcc)
pressing 'd' in 0.15 / CVS
If you don't know sql then maybe wait 'til 0.15 comes out.
Otherwise the relevant mySQL process (YMMV) seems to be:
(1) In profilegroups you have an id and a name - use this to identify
the one you want to delete.
(2) Now, in recordingprofiles you'll find a profilegroup column - you
want the recordingprofiles.id's of the records corresponding to the id
you found in (1)
(3) In codecparams you want to delete entries with the new ids you found
in (2)
(4) Back in recordingprofiles you want to delete the ones corresponding
to the id you found in (1)
(5) Finally delete the profilegroup entry found in (1)
FWIW I found http://www.fabforce.net/dbdesigner4/ which lets you import
the tables from mysql and 'model' them
It's a bit fiddly but it looks like it may be able to produce an E:R
diagram to let people see the intricacies of how Myth uses mysql...
David
More information about the mythtv-users
mailing list