[mythtv-users] hosed database (again) [solved]

[Mike McMullin]

On Fri, 2010-05-07 at 16:20 -0400, Mike McMullin wrote:
> On Wed, 2010-05-05 at 16:30 -0400, Mike McMullin wrote:
> > I'm not sure how this happened but my database is once again hosed.
> > 
> > When I try and start mysql I'm seeing these errors:
> > Running 'mysqlcheck'...
> > mysql.columns_priv                                 OK
> > mysql.db                                           OK
> > mysql.event                                        OK
> > mysql.func                                         OK
> > mysql.general_log
> > Error    : Can't find file: 'general_log' (errno: 2)
> > error    : Corrupt
> > mysql.help_category                                OK
> > mysql.help_keyword                                 OK
> > mysql.help_relation                                OK
> > mysql.help_topic                                   OK
> > mysql.host                                         OK
> > mysql.ndb_binlog_index                             OK
> > mysql.plugin                                       OK
> > mysql.proc                                         OK
> > mysql.procs_priv                                   OK
> > mysql.servers                                      OK
> > mysql.slow_log
> > Error    : Can't find file: 'slow_log' (errno: 2)
> > error    : Corrupt

  These two errors do not seem to be impeding mythtv, I'll need to grab
the logs later.

> > mythconverg.phonedirectory                         OK
> > : mythconverg.pidcache                               OK
> > Got error: 1102: Incorrect database name 'mythconverg.11-02-2009' when
> > selecting
> >  the databasemythconverg.playgroup                              OK
> 
>   Here's the offense by removing the directory named
> mythconverg.11-02-2009 from /var/lib/mysql, I was able to start mysql,
> and then mythtv, things seem back to normal, and I hope that no-one ever
> needs this info again!
> 
> > mythconverg.videosource                            OK
> > mythconverg.videotypes                             OK
> > mythconverg.websites                               OK
> > FATAL ERROR: Upgrade failed
> 
>   This as well.

  Seems to have self righted, I'll need to grab the logs.

>    [snip]