Impazamo yetafile yedatha ye-mysqld iphawulwe njengengqubano kunye neyokugqibela (ezenzekelayo?) isisombululo sokulungisa

mysqld impazamo yephepha ledatha iphawulwe njengengqubano kunye neyokugqibela (ezenzekelayo?) repair isisombululo

Eli nqaku liza kukwazisa kwiingcebiso zethu xa ulungisa itafileError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedisisombululo.

I-MYSQLKukho ingxaki kwiphepha ledatha, khawuleza ▼

Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed

mysql_upgrade yenza le miyalelo ilandelayo ukujonga kunye nokulungisa iitafile kunye nokuphucula inkqubo yeetafile ▼

mysqlcheck --all-databases --check-upgrade --auto-repair

• Ukungaphumeleli komsebenzi akubuyiseleki emva kwaye isiseko sedatha kufuneka simiswe:

  service monit stop

  service mysqld stop

• Ngenisa uvimba weenkcukacha apho uvimba weenkcukacha ukhona:

  cd /var/lib/mysql/db_name/

Qaphela: Inkonzo ye-mysql kufuneka imiswe ngaphambi kokuba umsebenzi ulungiswe.

• Lungisa idatha enye:

  myisamchk -r tablename.MYI

• Lungisa zonke iinkcukacha zedatha:

  myisamchk -r *.MYI

• Uhlobo olukhuselekile:

  myisamchk -r -v -o <table_name>

• Imo yokunyanzelisa:

  myisamchk -r -v -f <table_name>

ukusetyenziswa kwemyisamchk

Qaphela: Ngaphambi kokusebenzisa i-myisamchk, qiniseka ukuba i-mysqld ayifikeleli kwitafile ukuze ijongwe.Kungcono uyeke i-mysqld.

1. iqhutywe

   myisamchk –update-state -s *.myi

   , kwaye khangela ukuba zeziphi iifayile zesalathiso ezineengxaki (kungathatha ixesha elide).

2. Ukhetho lwemeko yohlaziyo lusetyenziswa kuphela xa umisa i-mysqld -s ithetha ukungahoyi ulwazi oluthile oluqhelekileyo loluhlu lwetafile kunye neempazamo zoluhlu kuphela.
3. Kwitafile nganye eyonakeleyo, zama

   myisamchk -r -q table_name

   Le yindlela yokulungisa ngokukhawuleza, eya kukhangela ngokuzenzekelayo ukuba itafile yesalathisi kunye nedatha yedatha inokuhambelana.Ukuba iyahambelana, inokulungiswa.

4. Ukuba indlela yokulungisa ngokukhawuleza ayiphumelelanga, qwalasela:

   myisamchk -r table_name

   Idatha engahambelaniyo kunye nezalathisi ziyacinywa, kwaye izalathisi zakhiwa kwakhona.

5. Ukuba oko akuphumeleli, qwalasela:

   myisamchk –safe-recover table_name

Umzekelo wokusebenza

Ukungaphumeleli komsebenzi akubuyiseleki emva kwaye isiseko sedatha kufuneka simiswe:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Lungisa zonke iinkcukacha zedatha:

myisamchk -r *.MYI

myisamchk -r -v -f wp_postmeta.MYI

myisamchk -r -v -f wp_posts.MYI

myisamchk -r -v -f wp_options.MYI

myisamchk -r -v -f wp_itsec_log

Oku kucotha kakhulu kuno -r, kodwa iphatha iimeko ezi -r zingenakho.

myisamchk -r -f -o /var/lib/mysql/eloha_ufo/wp_postmeta.MYI

Nanku umyalelo wendlela epheleleyo kwitafile yedatha:

myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_postmeta.MYI

myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_posts.MYI

Qalisa i-MYSQLD database:

service mysqld start

service mysqld restart

ukuqala eqalaMONIT Monitor:

service monit restart

service monit start