[mythtv-users] MySQL Guru Deleted Recordings

[Rob Davis]

Got it, thanks - also had to change RecGroup from Deleted..

Now to redelete the few shows we did want to delete.

On Wed, Apr 29, 2015 at 8:59 PM, dennis <deg at outlook.com> wrote:

>
>
> On 04/29/2015 08:35 PM, Rob Davis wrote:
>
>> So, using Kodi and the pvr-mythtv addon we successfully deleted all of
>> our recordings by accidents (using git 0.28).  I managed to save about a
>> weeks worth or recordings by moving them from the deleted storage group to
>> default before they all vanished.
>>
>> We came to terms with the loss, but I noticed the next day that my drive
>> space hadn't reduced that much.  Although the recordings were not available
>> in kodi or mythfrontend.  I did find them in mythweb.  I moved them using
>> that back into the default group.  However, they now show in mythweb, but
>> not on the frontend.  (Not sure about kodi as I updated everything in the
>> hope of getting the recordings showing - but the qt5 upgrade and database
>> schema broke the kodi addon (which I can live with).
>>
>> Using phpmyadmin, I notice that the recordings which are missing are
>> showing in the database with the field Delete Pending as 1, if I change
>> that to 0, then it will show up.
>>
>> Is there an SQL line that I can use which will change all recordings in
>> the database, fields delete pending to 0.  Or is there a way that I can
>> change this using mythweb.  To do it in phpmyadmin will take too long.
>>
>>  $ mysql -u mythtv -pmythtv mythconverg
>
> mysql>  update recorded set deletepending=0;
>
> Should work, but I didn't test it.   Hope this helps.
>
> Dennis
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150429/1fbcda06/attachment.html>