Phoso ea tafole ea data ea mysqld e tšoailoe e le e senyehileng le ea ho qetela (e iketsang?) tharollo ea ho lokisa

MySQLd phoso ea leqephe la data e tšoailoe e le e soahlamaneng le ea ho qetela (e iketsang?) repair tharollo

Sehlooho sena se tla u tsebisa malebela a rona ha u lokisa tafoleError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failedtharollo.

MySQLHo na le bothata ka leqephe la data, kapele ▼

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

mysql_upgrade e fana ka litaelo tse latelang ho hlahloba le ho lokisa litafole le ho ntlafatsa litafole tsa tsamaiso ▼

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

• Ho hloleha ha ts'ebetso ho ke ke ha khutlisoa 'me database e tlameha ho emisoa:

  service monit stop

  service mysqld stop

• Kenya lenane moo database e leng teng:

  cd /var/lib/mysql/db_name/

Tlhokomeliso: Ts'ebeletso ea mysql e tlameha ho emisoa pele ts'ebetso e lokisoa.

• Lokisa database e le 'ngoe:

  myisamchk -r tablename.MYI

• Lokisa lipampiri tsohle:

  myisamchk -r *.MYI

• Safe Mode:

  myisamchk -r -v -o <table_name>

• Qobella mokhoa:

  myisamchk -r -v -f <table_name>

tshebediso ya myisamchk

Tlhokomeliso: Pele o sebelisa myisamchk, etsa bonnete ba hore mysqld ha e fihle tafoleng e lokelang ho hlahlojoa.Ho molemo ho emisa mysqld.

1. e entsoe

   myisamchk –update-state -s *.myi

   , 'me u hlahlobe hore na ke lifaele life tsa index tse nang le mathata (ho ka nka nako e telele).

2. Khetho ea boemo ba ntlafatso e sebelisoa feela ha u emisa mysqld -s e bolela ho iphapanyetsa lintlha tse ling tse tloaelehileng tsa lethathamo la tafole le ho thathamisa liphoso feela.
3. Bakeng sa tafole e 'ngoe le e 'ngoe e senyehileng, leka

   myisamchk -r -q table_name

   Ena ke mokhoa oa ho lokisa kapele, o tla itlhahloba ka bohona hore na tafole ea index le tafole ea data e ka lumellana.Haeba e tsitsitse, e ka lokisoa.

4. Haeba mokhoa oa ho lokisa kapele o hloleha, nahana ka:

   myisamchk -r table_name

   Lintlha tse sa lumellaneng le li-index lia hlakoloa, 'me li-index lia tsosolosoa.

5. Haeba seo se hloleha, nahana ka:

   myisamchk –safe-recover table_name

Mohlala oa ts'ebetso

Ho hloleha ha ts'ebetso ho ke ke ha khutlisoa 'me database e tlameha ho emisoa:

service monit stop

service mysqld stop

cd /var/lib/mysql/eloha_ufo

cd /var/lib/mysql/eloha_cwl

Lokisa lipampiri tsohle:

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

Sena se lieha haholo ho feta -r, empa se sebetsana le maemo ao -r a ke keng a khona.

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

Mona ke taelo ea tsela e felletseng ea tafole ea database:

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

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

Qala database ea MYSQLD:

service mysqld start

service mysqld restart

e QALANGMONIT Mohlokomeli:

service monit restart

service monit start