[mythtv-users] Accidental DB Overwrite

[Jason Hamilton]

Hey Eric,

Yes I do have the log files and if not I do have them in splunk as well.
I'll have to go digging and see what I can come up with.

Thomas,

I made the mistake the other day of doing a select * from program and it
ran for the next 5 mins so there was some serious data in there.  I know in
mythweb you can roll back a few days.

Thank you everyone for your help with this.  If anyone has any thoughts on
a script for this please feel free to share :).

Jason

On Tue, Sep 1, 2015 at 2:38 PM, Thomas Mashos <thomas at mashos.com> wrote:

>
>
> On Tue, Sep 1, 2015 at 1:30 PM Hika van den Hoven <hikavdh at gmail.com>
> wrote:
>
>> Hoi Jason,
>>
>> Tuesday, September 1, 2015, 10:10:59 PM, you wrote:
>>
>> > So I just realized this afternoon that my DB got overwrote.  I thought
>> my
>> > backups were running but apparently they were not.  So my recordings
>> > currently only show up to Aug 25.  So everything thats recorded over the
>> > last 6 days doesn't show up.  Is there a way to have myth rescan the
>> > current recordings storage and attempt to do a repair of the recordings?
>> > BTW I have since fixed my DB backup and its back to running at full
>> steam
>> > once again.  Thank you all in advance for your help with this.
>>
>> You're best bet is importing them in the video database. You'll have
>> to identify what file is what, rename them to a name recognizable by the
>> video module (movie name or series name plus season episode) and place
>> them in your video directory.
>>
>> Tot mails,
>>   Hika                            mailto:hikavdh at gmail.com
>>
>> "Zonder hoop kun je niet leven
>> Zonder leven is er geen hoop
>> Het eeuwige dilemma
>> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>>
>> De lerende Mens
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>
>
> This made me wonder, how many days of past program data is kept. If the
> program data is there, it would seem feasible to be able to match when a
> recording took place on what channel and pull the correct data from it.
> --
> Thomas Mashos
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>


-- 
Jason Hamilton

Webmaster of www.thefuzz4.net

We're going to be huge
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150901/3d6f53d7/attachment.html>