<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Feb 4, 2015 at 11:02 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 01:55 PM, 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 3:56 PM, Mike Carron <<a href="mailto:jmcarron@starstream.net" target="_blank">jmcarron@starstream.net</a> <mailto:<a href="mailto:jmcarron@starstream.net" target="_blank">jmcarron@starstream.<u></u>net</a>>> wrote:<br>
<br>
<br>
On 02/04/2015 11:36 AM, Daryl McDonald wrote:<br>
<br>
<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><br></span>
<mailto:<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><span class=""><br>
<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"<br>
<<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a> <mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>><br></span>
<mailto:<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a><span class=""><br>
<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<br>
other Mike<br>
would be the best place to start. I tend to look at things<br>
in most<br>
systems from a more low level perspective of system<br>
administration<br>
and was not readily aware of that script. Good to know<br>
about :)<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> <mailto:<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.<u></u>org</a>><br></span>
<mailto:<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.<u></u>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>
Thanks Mike and Mike, I ran the "<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a><br></span>
<<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>> <<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>>" much<span class=""><br>
analysing and repairing goin' on. It seems now that MCC has<br>
been eradicated too, maybe a good thing because I was having<br>
problems with Mythexport, so How should I verify a utile<br>
database backup? Prior to this mishap I had been checking that<br>
the size of each new backup was bigger than the previous, and<br>
yet corruption snuck in. Should I be using "<a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a><br></span>
<<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>> <<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>>" on a<span class=""><br>
regular basis? Daryl<br>
<br>
***<br>
What I do may be overkill but...<br>
I moved the mythtv-database script (that's the script that does<br>
the mysql check and backs up the database) from cron.weekly to<br>
cron.daily;<br>
I added a line to that script to run <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a><br></span>
<<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>> after the backup completes.<span class=""><br>
So far so good.<br>
<br>
<br>
mike<br>
<br>
<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br></span><span class="">
<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>><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 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" target="_blank">optimize_mythdb.pl</a> <<a href="http://optimize_mythdb.pl" target="_blank">http://optimize_mythdb.pl</a>> in there along side mythtv_database. Doesn't that mean that it should already be running daily?<br>
<br>
</blockquote>
<br>
Yes it should be running daily. I did it the way I did as an attempt to make sure that <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> 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.<div class="HOEnZb"><div class="h5"><br>
<br>
mike<br>
<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>Upon a closer it was "optimize_mythdb" in cron.daily not "<a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a>" 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. </div></div><br></div></div>