[mythtvnz] Channel id to name tables: Where are they?

[Nick Rout]

>> Attached.
>>
>> Now none have have xmltvid
>
>
> This will add xmltvids for the channels you had xmltvids before:
> update channel set xmltvid = 'basefm.freeviewnz.tv' where channid = 3071;
> update channel set xmltvid = 'c4.freeviewnz.tv' where channid = 3009;
> update channel set xmltvid = 'four.freeviewnz.tv' where channid = 3004;
> update channel set xmltvid = 'maori-tv.freeviewnz.tv' where channid = 3005;
> update channel set xmltvid = 'parliament.freeviewnz.tv' where channid =
> 3022;
> update channel set xmltvid = 'prime.freeviewnz.tv' where channid = 3010;
> update channel set xmltvid = 'rnz-concert.freeviewnz.tv' where channid =
> 3051;
> update channel set xmltvid = 'rnz-national.freeviewnz.tv' where channid =
> 3050;
> update channel set xmltvid = 'tv1.freeviewnz.tv' where channid = 3001;
> update channel set xmltvid = 'tv2.freeviewnz.tv' where channid = 3002;
> update channel set xmltvid = 'tv3.freeviewnz.tv' where channid = 3033;
> update channel set xmltvid = 'tv3-plus1.freeviewnz.tv' where channid = 3008;
> update channel set xmltvid = 'u.freeviewnz.tv' where channid = 3006;
> commit;
>
> Probably you have lost all you recording rules. Did you make a backup of the
> database?

Why would he lose recording rules?