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

Nick Rout nick.rout at gmail.com
Mon Nov 23 00:41:54 UTC 2009

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?

More information about the mythtv-users mailing list