[mythtv-users] mythconverg

[Daryl McDonald]

On Wed, Feb 4, 2015 at 11:02 PM, Mike Carron <jmcarron at starstream.net>
wrote:

>
> On 02/04/2015 01:55 PM, Daryl McDonald wrote:
>
>>
>>
>> On Wed, Feb 4, 2015 at 3:56 PM, Mike Carron <jmcarron at starstream.net
>> <mailto:jmcarron at starstream.net>> wrote:
>>
>>
>>     On 02/04/2015 11:36 AM, Daryl McDonald wrote:
>>
>>
>>
>>         On Wed, Feb 4, 2015 at 2:15 PM, Mike Hodson <mystica at gmail.com
>>         <mailto:mystica at gmail.com> <mailto:mystica at gmail.com
>>         <mailto:mystica at gmail.com>>> wrote:
>>
>>
>>             On Feb 4, 2015 12:09 PM, "Daryl McDonald"
>>         <darylangela at gmail.com <mailto:darylangela at gmail.com>
>>             <mailto:darylangela at gmail.com
>>         <mailto:darylangela at gmail.com>>> wrote:
>>             >
>>             >
>>             > Thanks Mike MCC is mythbuntu control center.
>>             > Can you provide more step by step details on repairing all
>>             databases?
>>             >
>>             >
>>
>>             The reply qith MythTV's own script minutes ago by the
>>         other Mike
>>             would be the best place to start. I tend to look at things
>>         in most
>>             systems from a more low level perspective of system
>>         administration
>>             and was not readily aware of that script.  Good to know
>>         about :)
>>
>>             Mike
>>
>>
>>             _______________________________________________
>>             mythtv-users mailing list
>>         mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
>>         <mailto:mythtv-users at mythtv.org <mailto: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
>>
>>
>>         Thanks Mike and Mike, I ran the "optimize_mythdb.pl
>>         <http://optimize_mythdb.pl> <http://optimize_mythdb.pl>" much
>>         analysing and repairing goin' on. It seems now that MCC has
>>         been eradicated too, maybe a good thing because I was having
>>         problems with Mythexport, so How should I verify a utile
>>         database backup? Prior to this mishap I had been checking that
>>         the size of each new backup was bigger than the previous, and
>>         yet corruption snuck in. Should I be using "optimize_mythdb.pl
>>         <http://optimize_mythdb.pl> <http://optimize_mythdb.pl>" on a
>>         regular basis?   Daryl
>>
>>     ***
>>     What I do may be overkill but...
>>     I moved the mythtv-database script (that's the script that does
>>     the mysql check and backs up the database) from cron.weekly to
>>     cron.daily;
>>     I added a line to that script to run optimize_mythdb.pl
>>     <http://optimize_mythdb.pl> after the backup completes.
>>     So far so good.
>>
>>
>>     mike
>>
>>
>>     _______________________________________________
>>     mythtv-users mailing list
>>     mythtv-users at mythtv.org <mailto: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
>>
>>
>> Thanks Mike C., now that you mention it I recall making that move too,
>> and when I look at /etc/cron.daily I see optimize_mythdb.pl <
>> http://optimize_mythdb.pl> in there along side mythtv_database. Doesn't
>> that mean that it should already be running daily?
>>
>>
> Yes it should be running daily. I did it the way I did as an attempt to
> make sure that optimize_mythdb.pl didn't run while the backup was in
> progress or vice versa. I don't know that it is the "right" way to get the
> job done but it seems to work for me. I could also make an argument for
> running the optimize before the backup as well as after and frankly I'm not
> sure that either way is actually superior to the other.
>
>
> mike
>
>
>
> _______________________________________________
> 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
>

Upon a closer it was "optimize_mythdb" in cron.daily not "optimize_mythdb.pl"
so I added to the end of the script as suggested. When you think of it,
because it was optimized yesterday it got done before the backup, and will
also get done after the backup.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150204/5a900175/attachment-0001.html>