[mythtv-users] Question about using backup myth mysql dumps...

[stuart]

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
>> <mtdean at thirdcontact.com> 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.