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

[Michael T. Dean]

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?

Mike