[mythtvnz] Help needed to restore database

[Paulgir]

On Sun, 15 Jun 2014 16:03:32 +1200, Stephen Worthington  
<stephen_agent at jsw.gen.nz> wrote:

> On Sun, 15 Jun 2014 16:00:18 +1200, you wrote:
>
>> On Sun, 15 Jun 2014 15:48:59 +1200, Stephen Worthington
>> <stephen_agent at jsw.gen.nz> wrote:
>>
>>> On Sun, 15 Jun 2014 13:59:19 +1200, you wrote:
>>>
>>>> On Sun, 15 Jun 2014 13:48:52 +1200, Paulgir <paulgir at gmail.com> wrote:
>>>>
>>>>>
>>>>> I switched on my Myth box today to find that there were no recordings
>>>>> listed.Possibly this may be related to an optimize db cron job that  
>>>>> was
>>>>> scheduled last night ,but I can not be sure of that.
>>>>> I tried to restore a database back up from yesterday,but when I try
>>>>> mythconverg_restore.pl command I get command not found messages.
>>>>> I have tried this from the ~$ prompt and from the /usr/share/mythtv$
>>>>> prompt.
>>>>> Is they any other way I can do a db restore?
>>>>
>>>> I have just noticed that all the scheduled programs for the future are
>>>> still listed,though I am not sure what this means.Database not lost
>>>> after
>>>> all?
>>>
>>> The very first thing to do when having possible database problems is
>>> to do a manual backup of the database before touching anything.  In
>>> Mythbuntu, the backup and restore scripts are here:
>>>
>>>   /usr/share/mythtv/mythconverg_backup.pl
>>>   /usr/share/mythtv/mythconverg_restore.pl
>>>
>>> By default, Mythbuntu only does weekly backups from here:
>>>
>>>   /etc/cron.weekly/mythtv-database
>>>
>>> and they are stored in:
>>>
>>>   /var/lib/mythtv/db_backups
>>>
>>> I always add an edited copy of the mythtv-database file to:
>>>
>>>   /etc/cron.daily
>>>
>>> so that I get daily backups to a different hard drive as well as the
>>> weekly default ones.  I have my daily backups going to another PC on
>>> my network.  It pays from time to time to check that the backups are
>>> actually working by going to the destination directories and checking
>>> the file dates and sizes.
>>>
>>> It is also recommended that you turn on the option in Mythbuntu
>>> Control Center that does daily database optimizations.  That runs
>>> from:
>>>
>>>   /etc/cron.daily/optimize_mythdb
>>>
>>> Doing a daily check and repair seems to prevent most database
>>> corruptions from ever happening.
>>>
>>> If you have email working on your Mythbuntu box, you get a email from
>>> cron jobs like optimize_mythdb showing their log output.  I check that
>>> email every day to make sure the database is good.  When I installed
>>> smartd to monitor my hard drives (highly recommended!), it installed
>>> the email packages (I think it is postfix and mailx) so that it could
>>> email me when I have hard drive problems.  I am using the default
>>> email setup where I log in to a root command prompt and run the mail
>>> command to see the cron emails.  It is also possible to have the
>>> emails sent to a different address (eg your normal email account).
>>>
>>> What I would recommend for you to do now is first to check where your
>>> database backups are stored and see if they have been working
>>> properly.  If so, you should see a set of backup files of similar
>>> size.  Then copy those backups somewhere safe, as making further
>>> backups rotates the old ones, deleting the oldest every time a new one
>>> is made.
>>>
>>> Then run mythconverg_backup.pl manually (from a root prompt or with
>>> sudo) and make sure it works.  If the database is corrupt, sometimes
>>> it is corrupt enough to make backups fail.  In any case, if the backup
>>> succeeded or failed, you need to then manually run optimize_mythdb
>>> (from root) to check if the database is corrupt and to try to repair
>>> it.
>>>
>>
>> Ok .I'm officially an idiot.
>> Last night I left the group filter in "Deleted" and of course it started
>> today in "Deleted" with nothing to display.
>>
>> I will,however,go through and implement your suggestions.I currently  
>> have
>> daily mythdb backups occurring.
>> Thanks for the suggestions.
>
> That is why the devs added the ability to show the current filter name
> on screen (in 0.26 or 0.27 I think).  Does your theme do that?


Yes,that is why I accept my idiocy