Re: mysqld wont start...

From: The Natural Philosopher <a@xxx>
Date: Tue, 29 Jul 2008 12:51:51 +0100

Davide Bianchi wrote:

On 2008-07-29, The Natural Philosopher <a@xxx> wrote:
can't seem to find any log files to indicate what might be wrong..

In the data directory of mysql (/var/lib/mysql ?) there should be an
.err file with the errors, from what you said it sound like a file
corruption problem.

Davide

Foun some errors.

It appears half the system ISAM files are corrupted.Probably due to a power faluer when booting the deamon.

Myisamcheck goes ss far as to report 'not an ISAM file' on half of them. Ouch.

myisamchk *.MYI |more
myisamchk: error: 'columns_priv.MYI' is not a MyISAM-table
myisamchk: error: 'db.MYI' is not a MyISAM-table
myisamchk: error: 'func.MYI' is not a MyISAM-table
myisamchk: error: 'host.MYI' is not a MyISAM-table
myisamchk: error: 'proc.MYI' is not a MyISAM-table
myisamchk: error: 'tables_priv.MYI' is not a MyISAM-table
myisamchk: error: 'time_zone.MYI' is not a MyISAM-table
myisamchk: error: 'user.MYI' is not a MyISAM-table

Any one know how to sort this?
.

Follow-Ups:
- Re: mysqld wont start...
  - From: Jean-David Beyer

References:
- mysqld wont start...
  - From: The Natural Philosopher

Prev by Date: Re: Which linux version
Next by Date: Re: mysqld wont start...
Previous by thread: Re: mysqld wont start...
Next by thread: Re: mysqld wont start...
Index(es):
- Date
- Thread

Relevant Pages

Re: mysqld wont start...
... Foun some errors. ... It appears half the system ISAM files are corrupted.Probably due to a ... myisamchk: error: 'db.MYI' is not a MyISAM-table ...
(comp.os.linux.misc)
Re: mysqld wont start...
... corruption problem. ... Foun some errors. ... It appears half the system ISAM files are corrupted.Probably due to a ... myisamchk: error: 'db.MYI' is not a MyISAM-table ...
(comp.os.linux.misc)