[mythtv-users] cannot restore database

[UB40D]

On Sat, Feb 21, 2015 at 1:55 AM, Mike Hodson <mystica at gmail.com> wrote:

> Check your mysql error log, named 'yourhostname.err'  which will he
> wherever the database files live - often /var/lib/mysql/ - for any errors
> or oddities; the last lines should tell the tale.
>
>
Thanks for the tip.
I don't seem to have an error log in /var/lib/mysql. The only things I have
ending in .err are

find / -name '*.err' -print

/var/var/log/mail.err

/var/var/log/news/news.err

/var/var/log/mysql.err

/var/log/mail.err

/var/log/news/news.err
/var/log/mysql.err

and the two mysql.err files are both 0 bytes long.
I did however eventually find (this may help other mythbuntu users) that
/var/log/mysql was a directory full of error.log.?.gz and that the one for
yesterday had some data in it, saying that a bunch of mythconverg tables
were "marked as crashed and should be repaired".

> Based on the error you may have more tables to repair or maybe a corrupt
> innodb if you use that table type.  But the logs should give you some idea
> of what to try next.  Bpaste.net if you'd like more eyes on them.
>
Much appreciated... it doesn't give me much of a hint personally! I thought
dropping the database, recreating it and restoring it would get rid of all
those tables and replace them with good copies anyway, so this doesn't tell
me why the script freezes at "dropping database". Here's the whole file.

https://bpaste.net/show/7b5116952ccd

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150221/745c4c89/attachment.html>