hack

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??
Dabitch 1 min read
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!

Share
Comments
More from Everything is so random there must be a pattern.
Country of origin displayed as flags on X - a chrome plugin.
hack

Country of origin displayed as flags on X - a chrome plugin.

Over the weekend, X's head of product Nikita Bier dropped a nuclear bomb - it showed country of origin if a user looked at another users "about" section. The amount of "tradwife", pro-MAGA, pro-Euronationalism etc accounts that turned out to be from India, Saudi, Thailand or Nigeria was staggering.
Dabitch 2 min read

Everything is so random there must be a pattern.

Hi, I'm Åsk, I'm a geeky art director working in advertising and industrial design. Here I share whatever is on my mind and the occasional script.

Great! You’ve successfully signed up.

Welcome back! You've successfully signed in.

You've successfully subscribed to Everything is so random there must be a pattern. .

Success! Check your email for magic link to sign-in.

Success! Your billing info has been updated.

Your billing was not updated.