Re: mysqld wont start...

Jean-David Beyer wrote:
The Natural Philosopher wrote:
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?

Restore from backup?

P.S.: Also get a UPS on that machine so it will not happen again.

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 08:25:01 up 8 days, 13:13, 4 users, load average: 4.10, 4.09, 4.09
.

Relevant Pages

  • Re: mysqld wont start...
    ... Foun some errors. ... It appears half the system ISAM files are corrupted.Probably due to a power faluer when booting the deamon. ... 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)