<br><br><div class="gmail_quote">2010/1/26 Glenn B. Lawler <span dir="ltr"><<a href="mailto:gblawler@incodesystems.com">gblawler@incodesystems.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I would like to run a script with:<br>
<br>
mysqlrepair mythconverg {tablename}<br>
<br>
for each table on startup.<br>
<br>
I am running MythTV 0.21 under gentoo.<br>
<br>
Could someone send me information about how to include such a script in the startup procedure?<br>
<div><div></div><div class="h5"><br></div></div></blockquote><div>I run a rotating backup and database check on shutdown, figured this was better as usually I don't care if it takes a little while to shutdown, but I do want it to boot promptly.<br>
<br>I recently added the rotating backup (using the script supplied with myth that I forget the name of off the top of my head) after a recent crash wiped out my programs table. (that was a fun few hours of fixing. :) )<br>
<br>The relevant sections from my /etc/init.d/mythtv script (run on shutdown):-<br><br> log_action_msg "Killing mythbackend"<br>
pkill mythbackend<br>
log_action_msg "Checking and repairing database"<br> mysqlcheck -r -umythtv -pmythtv mythconverg 2>&1 >/dev/null<br> log_action_msg "Optimizing database"<br> mysqlcheck -o -umythtv -pmythtv mythconverg 2>&1 >/dev/null<br>
log_action_msg "Backing up myth database"<br> /usr/local/mythtv/share/mythtv/<a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a> /home/mythtv/.mythtv/backuprc<br><br><br>NB: My myth is installed in a non standard prefix, so the <a href="http://mythconver_backup.pl">mythconver_backup.pl</a> script may not be where I say it is. :), it's prob in /usr/local/share/mythtv<br>
<br>NB2: My pvr is behind a firewall, so I'm not worried about having connection passwords in scripts, if you are, this may not be a viable solution for you.<br><br>Cheers,<br><br>Ian<br><br></div></div><br>