When your mysql server has crashed and won't restart, it probably needs repair

But egads, how do you repair it when you can't start it??

First, find the dang mysql files. The data usuallly hides in /var/mysql - this is uncool because that'll eat up your root partition - try something like /opt/bitnami/mysql/ or somehwere.... /stack/mysql/data if you have it on another EDS

Then

myisamchk -fr *MYI

You'll probably run into this too:
 

MyISAM-table 'whatever.MYI' is not fixed because of errors

Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

Oh, and when you DO get that database started again, do mysqlcheck -Arp

Enjoy!

Post Details

Category

Geek

Date

Sat, 04/11/2015 - 02:23

Author

Dabitch

Share it:

Leave a Comment

Log in to post comments