[mythtv-users] mysql restart - failed

[Ryan Ollerenshaw]

On 10/1/07, Jonathan Rogers <jonner at teegra.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Ryan Ollerenshaw wrote:
> > When i try to restart the mysql database from the command line it
> > returned failed.  I cannot find any info on what to do about this,
> > anyone have any ideas on were to get started?
>
> Well, to see what's going on with a daemon like mysqld, always look at
> the log. On my Ubuntu system, mysql messages show up in
> /var/log/daemon.log. To make helping you easier, you can specify your
> distribution and how you tried to restart mysql.
>
> Jonathan Rogers

i am using knoppmyth R5.  I tried to use command /etc/init.d/mysql
restart. which then reports failed.  I checked the log files in
/var/log and none of them seemed to report any mysql errors and the
log files for mysql were all blank, so no help there.  I tired looking
in the directroy /var/run/mysqld/ as suggested by another post and i
got the following error:

EXT3-fs error (device hda 1): ext3_readdir: directory #479638 contains
a hole at offset 0

the directroy /var/lib/mysql seems to be fine though.