Akara njehie tebụl data mysqld ka ọ dara na nke ikpeazụ (akpaaka?) ngwọta mmezi

A na-akara njehie tebụl MySQL dị ka ihe mebiri emebi na nke ikpeazụ (akpaka?) - ngwọta.

Isiokwu a ga-ewebata gị ndụmọdụ anyị mgbe ị na-arụkwa tebụlError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedngwọta.

E nwere nsogbu na tebụl MySQL , dịka ozi a si gosi: ▼

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

mysql_upgrade na-eme iwu ndị a ka ịlele na rụkwaa tebụl na kwalite tebụl sistemụ ▼

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

• Ọdịda nke ọrụ ahụ enweghị ike ịgbagha na nchekwa data ga-akwụsịrịrị:

  service monit stop

  service mysqld stop

• Tinye ndekọ ebe nchekwa data dị:

  cd /var/lib/mysql/db_name/

Mara: A ga-akwụsịrịrị ọrụ mysql tupu arụkwa ya.

• Dozie otu mpempe akwụkwọ data:

  myisamchk -r tablename.MYI

• Dozie akwụkwọ data niile:

  myisamchk -r *.MYI

• Ọnọdụ nchekwa:

  myisamchk -r -v -o <table_name>

• Ụdị mmanye:

  myisamchk -r -v -f <table_name>

myisamchk ojiji

Mara: Tupu iji myisamchk, gbaa mbọ hụ na mysqld anaghị abanye na tebụl a ga-elele.Ka mma kwụsị mysqld.

1. rụrụ

   myisamchk –update-state -s *.myi

   , wee lelee faịlụ ndeksi nwere nsogbu (nwere ike were ogologo oge).

2. A na-eji nhọrọ nwelite steeti naanị mgbe ị kwụsịrị mysqld -s pụtara ileghara ụfọdụ ozi ndepụta tebụl nkịtị na naanị ndetu mperi.
3. Maka tebụl ọ bụla mebiri emebi, gbalịa

   myisamchk -r -q table_name

   Nke a bụ ọnọdụ nrụzi ngwa ngwa, nke ga-enyocha ozugbo ma tebụl index na tebụl data nwere ike ịdị na-agbanwe agbanwe.Ọ bụrụ na ọ na-agbanwe agbanwe, enwere ike idozi ya.

4. Ọ bụrụ na ọnọdụ ndozi ngwa ngwa adaghị, tụlee:

   myisamchk -r table_name

   A na-ehichapụ data na ndenye aha na-ekwekọghị ekwekọ, ma wughachi ndektị.

5. Ọ bụrụ na nke ahụ ada, tụlee:

   myisamchk –safe-recover table_name

Ihe atụ ọrụ

Ọdịda nke ọrụ ahụ enweghị ike ịgbagha na nchekwa data ga-akwụsịrịrị:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Dozie akwụkwọ data niile:

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

Nke a dị nwayọ karịa -r, mana ọ na-ejikwa ọnọdụ ndị -r enweghị ike.

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

Nke a bụ iwu maka ụzọ zuru ezu na tebụl nchekwa data:

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

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

Malite nchekwa data MYSQLD:

service mysqld start

service mysqld restart

Malite mmemme nlekota MONIT :

service monit restart

service monit start