Papa Kuhikuhi ʻatikala
mysqld ua hōʻailona ʻia ka hewa pepa ʻikepili i hāʻule a hope (akomi?) repair hoʻonā
E hoʻolauna kēia ʻatikala iā ʻoe i kā mākou ʻōlelo aʻoaʻo i ka wā e hoʻoponopono ai i ka papaʻainaError: Table \'./db_name/table_name\' is marked as crashed and last (automatic?) repair failed
hoʻonā.
MySQLAia ka pilikia me ka pepa ʻikepili, koi ▼
Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed
hoʻokō ʻo mysql_upgrade i kēia mau kauoha e nānā a hoʻoponopono i nā papa a hoʻomaikaʻi i nā papa ʻōnaehana ▼
mysqlcheck --all-databases --check-upgrade --auto-repair
- ʻAʻole hiki ke hoʻohuli ʻia ka hāʻule ʻole o ka hana a pono e kāpae ʻia ka waihona:
service monit stop
service mysqld stop
- E komo i ka papa kuhikuhi kahi i loaʻa ai ka waihona:
cd /var/lib/mysql/db_name/
'Ōlelo Aʻo: Pono ka lawelawe mysql ma mua o ka hoʻoponopono ʻana i ka hana.
- Hoʻoponopono i ka ʻikepili hoʻokahi:
myisamchk -r tablename.MYI
- Hoʻoponopono i nā ʻikepili āpau:
myisamchk -r *.MYI
- ʻAno palekana:
myisamchk -r -v -o <table_name>
- Ke ano ikaika:
myisamchk -r -v -f <table_name>
hoʻohana myisamchk
'Ōlelo Aʻo: Ma mua o ka hoʻohana ʻana i ka myisamchk, e hōʻoia ʻaʻole i komo ka mysqld i ka papa e nānā ʻia.ʻOi aku ka maikaʻi e kāpae i ka mysqld.
- hāpai i waho
myisamchk –update-state -s *.myi
, a nānā i nā faila kuhikuhi i pilikia (hiki ke lōʻihi).
- Hoʻohana wale ʻia ke koho hou-state i ka wā e hoʻōki ai i ka mysqld -s ʻo ia ka mea e haʻalele i kekahi ʻike papa inoa papa maʻamau a papa inoa wale i nā hewa.
- No kēlā me kēia pākaukau ʻino, e hoʻāʻo
myisamchk -r -q table_name
ʻO kēia ke ʻano hoʻoponopono wikiwiki, e nānā ʻokoʻa inā hiki ke kūlike ka papa kuhikuhi a me ka papa ʻikepili.Inā kūlike, hiki ke hoʻopaʻa ʻia.
- Inā hāʻule ke ʻano hoʻoponopono wikiwiki, e noʻonoʻo:
myisamchk -r table_name
Holoi ʻia nā ʻikepili like ʻole a me nā kuhikuhi, a kūkulu hou ʻia nā kuhikuhi.
- Inā hāʻule kēlā, e noʻonoʻo:
myisamchk –safe-recover table_name
Laʻana hana
ʻAʻole hiki ke hoʻohuli ʻia ka hāʻule ʻole o ka hana a pono e kāpae ʻia ka waihona:
service monit stop
service mysqld stop
cd /var/lib/mysql/eloha_ufo
cd /var/lib/mysql/eloha_cwl
Hoʻoponopono i nā ʻikepili āpau:
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
ʻOi aku ka lohi ma mua o -r, akā mālama i nā kūlana i hiki ʻole -r.
myisamchk -r -f -o /var/lib/mysql/eloha_ufo/wp_postmeta.MYI
Eia ke kauoha no ke ala piha i ka papa waihona waihona:
myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_postmeta.MYI
myisamchk -r -f /var/lib/mysql/eloha_ufo/wp_posts.MYI
E hoʻomaka i ka waihona MYSQLD:
service mysqld start
service mysqld restart
hoʻomakaNānā MONIT:
service monit restart
service monit start
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) ʻO ka "mysqld data table error is marked as crashed and last (automatic?) repair solution" i haʻi ʻia e ʻoe e kōkua iā ʻoe.
Welina mai e kaʻana like i ka loulou o kēia ʻatikala:https://www.chenweiliang.com/cwl-176.html
Welina mai i ke kahawai Telegram o ka moʻomanaʻo ʻo Chen Weiliang e kiʻi i nā mea hou loa!
📚 He waiwai nui kēia alakaʻi, 🌟He manawa kakaikahi kēia, mai poina! ⏰⌛💨
Kaʻana like a like inā makemake ʻoe!
ʻO kāu kaʻana like a me kou makemake ʻo kā mākou hoʻoikaika mau!