<div dir="ltr"><br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class="">
# mysql -umythtv -p mythconverg -e "DROP DATABASE IF EXISTS mythconverg;"<br>
<br></span></blockquote></div></div></div></blockquote><div><br></div><div>This command freezes forever without producing output. This is at least consistent with this command...</div><div><br></div><div><a href="http://mythconverg_restore.pl/" target="_blank" style="font-size:13px">mythconverg_restore.pl</a><span style="font-size:13px"> --drop_database --create_database --verbose --filename  mythconverg-1317-</span><span style="font-size:13px">20150220033002.sql.gz </span><br></div><div><br></div><div>...also freezing after saying...</div><div><br></div><div><span style="font-size:13px">Preparing initial database.</span><br style="font-size:13px"><span style="font-size:13px">Dropping database.</span><br></div><div><br></div><div>Even just connecting to the database manually never gives me a prompt:</div><div><br></div><div><p style="margin:0px;font-size:13px;font-family:Fixed">mysql --user=mythtv --password=XXXXX mythconverg</p><p style="margin:0px;font-size:13px;font-family:Fixed"><br></p><p style="margin:0px;font-size:13px;font-family:Fixed">...just outputs the following and locks up until I control-C:</p><p style="margin:0px;font-size:13px;font-family:Fixed"><br></p><p style="margin:0px;font-size:13px;font-family:Fixed">Reading table information for completion of table and column names</p><p style="margin:0px;font-size:13px;font-family:Fixed">
</p><p style="margin:0px;font-size:13px;font-family:Fixed">You can turn off this feature to get a quicker startup with -A</p></div><div><br></div><div>I got suspicious. I did</div><div><br></div><div><p style="margin:0px;font-size:13px;font-family:Fixed"> sudo service mysql restart</p><p style="margin:0px;font-size:13px;font-family:Fixed"><br></p><p style="margin:0px;font-size:13px;font-family:Fixed">and, after that, this command gave me a prompt:</p><p style="margin:0px;font-size:13px;font-family:Fixed"><br></p><p style="font-size:13px;margin:0px;font-family:Fixed">mysql --user=mythtv --password=XXXXX mythconverg</p><p style="margin:0px;font-size:13px;font-family:Fixed"><br></p><p style="margin:0px;font-size:13px;font-family:Fixed">Then I tried running the original restore command:</p><p style="margin:0px;font-size:13px;font-family:Fixed"><br></p><p style="margin:0px;font-size:13px;font-family:Fixed"><a href="http://mythconverg_restore.pl/" target="_blank" style="font-family:arial,sans-serif">mythconverg_restore.pl</a><span style="font-family:arial,sans-serif"> --drop_database --create_database --verbose --filename  mythconverg-1317-</span><span style="font-family:arial,sans-serif">20150220033002.sql.gz </span><br></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif"><br></span></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif">Again it froze at "dropping database".</span></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif"><br></span></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif">I did control-C and tried your</span></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif"><br></span></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif;font-size:small">mysql -umythtv -p mythconverg -e "DROP DATABASE IF EXISTS mythconverg;"</span><br style="font-family:arial,sans-serif"></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif;font-size:small"><br></span></p><p style="margin:0px">and that also froze without output. What's stopping me from dropping the database? Maybe some higher-level mysql housekeeping table (e.g. one that says what databases are available) is also corrupted and needs repair before I can drop the mythconverg database?</p><p style="margin:0px"><br></p><p style="margin:0px">I confirm that mysql is running and that I can get in, with the same userid and password, and get a prompt.</p><p style="margin:0px"><br></p><p style="margin:0px">What now?</p><p style="margin:0px"><br></p><p style="margin:0px;font-size:13px;font-family:Fixed"><span style="font-family:arial,sans-serif"><br></span></p><p style="margin:0px;font-size:13px;font-family:Fixed"> <br></p></div></div></div></div>