<br><br><div class="gmail_quote">On Thu, Jul 8, 2010 at 9:24 AM, Phil Linttell <span dir="ltr"><<a href="mailto:phil.linttell@rogers.com">phil.linttell@rogers.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I'm currently running Trunk (25279) and all my recordings have all<br>
disappeared from "Watch Recordings", apart from one program that has<br>
just finished recording. I've verified that my recordings drive is<br>
mounted, and the recordings themselves can be played from mplayer. I've<br>
run <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a>, and restarted the back-end.... still no recordings.<br>
<br>
The table seems to have been wiped. The "recorded" table in mysql has<br>
only the one, new, row in it.<br>
<br>
Looking at "Previously Recorded" programs appears to be intact. The<br>
other tables appear to be fine too, as far as I can tell. Videos,<br>
recording rules.... all okay.<br>
<br>
What's the best approach to recovering/re-populating the table? The<br>
last database backup was done about a week ago, as part of the schema<br>
upgrade from 0.23-fixes to trunk... do I need to restore the<br>
database? Or can I just use <a href="http://myth.find_orphans.pl" target="_blank">myth.find_orphans.pl</a> to put everything back?<br>
<br>
As for why the table disappeared... I had a power failure last<br>
night.... could that account for one table in a mysql database vanishing?<br></blockquote><div><br></div><div>Yes. I recently had a database crash of some kind while I was away that took out 14 tables in my mythconverg. In MySQL, they are files so they can be damaged individually. Restoring that table from backup is your best option. I believe the official recommendation would be to restore the entire DB to it's pre-trunk upgrade state and let trunk re-do the schema upgrades, etc. </div>
<div><br></div><div>This would also be a good time to look into some simple scripts to backup/dump the database regularly to another drive.</div><div><br></div><div>Kevin</div></div>