On 6/24/06, <b class="gmail_sendername">M Smith</b> <<a href="mailto:quaffapint@clippersoft.net">quaffapint@clippersoft.net</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Help!<br><br>After a power outage, my mythtv box (combined frontend/backend) rebooted<br>and all seemed well. I could play existing recently recorded shows<br>without issue.<br><br>Then I tried to connect via mythweb and nothing happened - just hung. I
<br>then tried to run a mysqldump to backup the database and it hung. Next<br>I tried running a mysqlcheck and its hung right after<br>'mythconverg.profilegroups' and pegging mysqld for quite some time.<br><br>So - I'm here asking what can I do ?! I don't have a recent backup of
<br>the database to restore from (stupid, I know). I'm thinking I might<br>need to re-do the database, but I don't want to lose the tons of info I<br>have on all my recordings/vidoes/music.<br><br>Is there any suggestions on how to possibly fix the database? If not,
<br>is there any way to have Myth re-create the database with at least some<br>of the info?</blockquote><div><br>Shutdown mythbackend and then run:<br>mysqlcheck -A -r -p <br></div><br></div>