mysqld data tafura kukanganisa kwakanyorwa sekuparara uye kwekupedzisira (otomatiki?) kugadzirisa mhinduro

mysqld data sheet kukanganisa yamaka seyakapwanyika uye yekupedzisira (otomatiki?) repair mhinduro

Ichi chinyorwa chichakuzivisa iwe kune mazano edu pakugadzirisa tafuraError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedmhinduro.

MySQLPane dambudziko nebepa re data, nekukurumidza ▼

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

mysql_upgrade inoita iyo inotevera mirairo yekutarisa uye kugadzirisa matafura uye kusimudzira system matafura ▼

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

• Iko kutadza kwekushanda hakuchinjike uye dhatabhesi rinofanira kumiswa:

  service monit stop

  service mysqld stop

• Pinda dhairekitori pane database iripo:

  cd /var/lib/mysql/db_name/

Ongorora: Iyo mysql sevhisi inofanirwa kumiswa basa risati ragadziriswa.

• Gadzirisa dheta rimwe chete:

  myisamchk -r tablename.MYI

• Gadzirisa mapepa ese:

  myisamchk -r *.MYI

• Safe Mode:

  myisamchk -r -v -o <table_name>

• Kumanikidza maitiro:

  myisamchk -r -v -f <table_name>

myisamchk kushandiswa

Cherechedza: Usati washandisa myisamchk, ita shuwa kuti mysqld haisi kuwana tafura kuti itariswe.Zvirinani kumira mysqld.

1. shandisa

   myisamchk –update-state -s *.myi

   , uye tarisa kuti ndeapi mafaera ane indekisi ane matambudziko (angatora nguva yakareba).

2. Iyo yekuvandudza-state sarudzo inongo shandiswa pakumisa mysqld. -s zvinoreva kufuratira mamwe akajairwa tafura yerondedzero ruzivo uye kungonyora zvikanganiso.
3. Patafura yega yega yakaora, edza

   myisamchk -r -q table_name

   Iyi ndiyo nzira yekukurumidza kugadzirisa, iyo inongotarisa kana iyo index index uye tafura yedata inogona kuenderana.Kana ichienderana, inogona kugadziriswa.

4. Kana kukurumidza-kugadzirisa modhi ikatadza, funga:

   myisamchk -r table_name

   Data risingaenderani uye indexes zvinodzimwa, uye indexes anovakwa patsva.

5. Kana izvo zvisingakwanisi, funga:

   myisamchk –safe-recover table_name

Muenzaniso wekushanda

Iko kutadza kwekushanda hakuchinjike uye dhatabhesi rinofanira kumiswa:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Gadzirisa mapepa ese:

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

Izvi zvinononoka kupfuura -r, asi zvinobata mamiriro ayo -r asingagone.

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

Heino murairo weiyo nzira yakazara kune tafura yedatabase:

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

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

Tanga iyo MYSQLD database:

service mysqld start

service mysqld restart

tangaMONIT Monitor:

service monit restart

service monit start