Mailing List Archive: recordings restored from backup, how to fix database?

recordings restored from backup, how to fix database?

Jan 8, 2022, 8:32 AM

Post #1 of 4 (317 views)

My mythtv recordings partition was irrecoverably corrupted. But I
have a backup from six months ago. I don't have a corresponding
database backup. So I want to align the existing database to match
the recordings on the HDD.

Any HDD recording or DB entry that doesn't have a corresponding DB
entry or HDD recording should be deleted. That is all I need and I'll
be happy.

I remember there used to be a "fix myth database" script. Has that
been maintained? Would it do what I need in this case?
_____________
Ryan Patterson
May the wings of liberty never lose a feather.
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: recordings restored from backup, how to fix database? [ In reply to ]

philledwards at gmail

Jan 8, 2022, 4:44 PM

Post #2 of 4 (316 views)

Permalink

ryan.goat@gmail.com> wrote:

> My mythtv recordings partition was irrecoverably corrupted. But I
> have a backup from six months ago. I don't have a corresponding
> database backup. So I want to align the existing database to match
> the recordings on the HDD.
>
> Any HDD recording or DB entry that doesn't have a corresponding DB
> entry or HDD recording should be deleted. That is all I need and I'll
> be happy.
>
> I remember there used to be a "fix myth database" script. Has that
> been maintained? Would it do what I need to do?

Is this what you were thinking of?
https://www.mythtv.org/wiki/Find_orphans.py

>
>

Re: recordings restored from backup, how to fix database? [ In reply to ]

gregL at nycap

Jan 8, 2022, 5:37 PM

Post #3 of 4 (316 views)

Permalink

On 1/8/22 7:44 PM, Phill Edwards wrote:
> ryan.goat@gmail.com> wrote:
>
> My mythtv recordings partition was irrecoverably corrupted. But I
> have a backup from six months ago. I don't have a corresponding
> database backup. So I want to align the existing database to match
> the recordings on the HDD.
>
> Any HDD recording or DB entry that doesn't have a corresponding DB
> entry or HDD recording should be deleted. That is all I need and I'll
> be happy.
>
> I remember there used to be a "fix myth database" script. Has that
> been maintained? Would it do what I need to do?
>
>
> Is this what you were thinking of?
> https://www.mythtv.org/wiki/Find_orphans.py

Check out the Mythtv fourm. There is a thread called Mythconverg
corrupt. There is some information there that may help you..

https://forum.mythtv.org/viewtopic.php?t=3834

Good luck

>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums:https://forum.mythtv.org

Re: recordings restored from backup, how to fix database? [ In reply to ]

ryan.goat at gmail

Jan 8, 2022, 7:35 PM

Post #4 of 4 (315 views)

Permalink

On Sat, Jan 8, 2022 at 7:45 PM Phill Edwards <philledwards@gmail.com> wrote:
>
> ryan.goat@gmail.com> wrote:
>>
>> My mythtv recordings partition was irrecoverably corrupted. But I
>> have a backup from six months ago. I don't have a corresponding
>> database backup. So I want to align the existing database to match
>> the recordings on the HDD.
>>
>> Any HDD recording or DB entry that doesn't have a corresponding DB
>> entry or HDD recording should be deleted. That is all I need and I'll
>> be happy.
>>
>> I remember there used to be a "fix myth database" script. Has that
>> been maintained? Would it do what I need to do?
>
>
> Is this what you were thinking of?
> https://www.mythtv.org/wiki/Find_orphans.py

Yes. That is the exact script I was talking about. Thank you.
_____________
Ryan Patterson
May the wings of liberty never lose a feather.
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org