<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Feb 4, 2015 at 3:56 PM, Mike Carron <span dir="ltr"><<a href="mailto:jmcarron@starstream.net" target="_blank">jmcarron@starstream.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
On 02/04/2015 11:36 AM, Daryl McDonald wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
<br>
<br>
On Wed, Feb 4, 2015 at 2:15 PM, Mike Hodson <<a href="mailto:mystica@gmail.com" target="_blank">mystica@gmail.com</a> <mailto:<a href="mailto:mystica@gmail.com" target="_blank">mystica@gmail.com</a>>> wrote:<br>
<br>
<br>
On Feb 4, 2015 12:09 PM, "Daryl McDonald" <<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a><br></span><span class="">
<mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>><u></u>> wrote:<br>
><br>
><br>
> Thanks Mike MCC is mythbuntu control center.<br>
> Can you provide more step by step details on repairing all<br>
databases?<br>
><br>
><br>
<br>
The reply qith MythTV's own script minutes ago by the other Mike<br>
would be the best place to start. I tend to look at things in most<br>
systems from a more low level perspective of system administration<br>
and was not readily aware of that script. Good to know about :)<br>
<br>
Mike<br>
<br>
<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br></span>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a> <mailto:<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.<u></u>org</a>><span class=""><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/<u></u>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/<u></u>Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a><br>
<br>
<br></span>
Thanks Mike and Mike, I ran the "<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> <<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>>" 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 "<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> <<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>>" on a regular basis? Daryl<br>
<br>
</blockquote>
***<br>
What I do may be overkill but...<br>
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;<br>
I added a line to that script to run <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> after the backup completes.<br>
So far so good.<div class="HOEnZb"><div class="h5"><br>
<br>
mike<br>
<br>
<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/<u></u>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/<u></u>Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a></div></div></blockquote><div><br></div><div>Thanks Mike C., now that you mention it I recall making that move too, and when I look at /etc/cron.daily I see <a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> in there along side mythtv_database. Doesn't that mean that it should already be running daily? </div></div><br></div></div>