[mythtv-users] Question about using backup myth mysql dumps...
Michael T. Dean
mtdean at thirdcontact.com
Mon Nov 23 03:30:22 UTC 2009
On 11/22/2009 10:34 PM, stuart wrote:
> Michael T. Dean wrote:
>> On 11/22/2009 07:41 PM, Nick Rout wrote:
>>> On Mon, Nov 23, 2009 at 1:12 PM, Michael T. Dean wrote:
>>>> On 11/22/2009 12:28 PM, stuart wrote:
>>>>> In my hast, I have created a bunch of orphaned recordings (100+).
>>>>> Information about them still exists in the old mythtv data base,
>>>>> but I
>>>>> think putting the old mythtv data base back into mysql would be a
>>>>> mistake as the data base dump is months old. So, I've come to the
>>>>> conclusion the best thing to do is wade through the recordings,
>>>>> rename
>>>>> the keepers to something a human can read and place them into a
>>>>> mythtv
>>>>> video directory.
>>>>>
>>>>> However, I can't help but think it might be possible to still use the
>>>>> old mythtv data base dump to rename these files to something a human
>>>>> can read! (That would be waaaay faster then spot checking them with
>>>>> video player!)
>>>>>
>>>>> Anyone have ideas on how to do this (i.e. use an old mysql data base
>>>>> dump to rename mythtv recordings)?
>>>>>
>>>> I'd argue that it would be better, easier, and you'd retain more and
>>>> better information if you restored the old database, then went through
>>>> and deleted all the shows whose files are missing.
>>>>
>>>
>>> But what about shows that have been added into the database since the
>>> old database was backed up?
>>
>> Don't you have a current database you can just back up?
>
> Why yes, but ... I don't remember seeing any mythtv howto's on merging
> old and new data base dumps.
>
> Also, (didn't want to bore you) I have cleaned up the recording rules
> a fair bit since the old data base dump (seams a lot of people were
> just pressing "record" in the program listings creating multiple rules
> for the same shows!).
>
> A friend suggested there might be a way to harvest each orphaned
> recording's information from the old data base and use "INSERT" to
> place the information into the new data base. It is trivial to create
> a clean list of orphaned recording files. What I don't know is how to
> extract from the old dump and insert into the new.
So the orphans are orphaned files for which someone deleted your
database metadata?
Mike
More information about the mythtv-users
mailing list