Chinyorwa Directory
BACKWPUP plugin yambiro-haigone-kurodha-kubva-mysqlproc-the-tafura-inogona-ine-huori
WAARSCHUWING: Databasefout Haikwanise kurodha kubva mysql.proc.
Yambiro iyi yakakomba sei?Chii chingaitwa kugadzirisa?
Izvi zvinokonzerwa nekuchinja kwe schema kunodiwa nemhando dzakasiyana dzeMySQL server.Nzira iri nyore yekugadzirisa iyi ndeyekumhanyisa mysql_upgrade command kubva kumutsara wekuraira.
Nezve mysql_upgrade
mysql_upgrade inotarisa matafura ese mune ese dhatabhesi kuti asaenderane neyazvino vhezheni yeMySQL server. mysql_upgrade zvakare inokwidziridza matafura ehurongwa kuitira kuti maropafadzo matsva kana maficha angave akawedzerwa anogona kushandiswa.
mysql_upgrade inofanira kuitwa nguva dzose MySQL painokwidziridzwa.Inotsiva yekare mysql_fix_privilege_tables script, iyo isingachafanira kushandiswa.
mysql_upgrade inoita iyo inotevera mirairo yekutarisa uye kugadzirisa matafura uye kukwidziridza system matafura:
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql fix_priv_tables
Mhanya mysql_upgrade kubva pamutsetse wekuraira
Kuti ushandise mysql_upgrade, ita shuwa kuti MySQL server iri kushanda, wobva wadaidza mysql_upgrade kubva kune yekuraira mutsara chishandiso:
mysql_upgrade -uroot -p --force
Iwe unofanirwa kubva wakumbirwa password yeMySQL mudzi, uye mysql_upgrade inotarisa ese dhatabhesi uye matafura uye kugadzirisa pazvinenge zvakakodzera.
Ungangoda kutsanangura nzira izere yekuraira iri pamusoro kana isiri munzira yekutsvaga yegoko.
PaDebian 6, inofanirwa kunge iri mu:
/usr/bin/mysql_upgrade -uroot -p --force
PaMAMP yeMac, iyo yakasarudzika nzira ndeye:
/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force
PaWindows, MySQL ichaiswa uye inosanganisirwa mubhini subdirectory.By default inofanira kunge iri pa:
"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown
Finish!
Mushure mekuita mysql_upgrade, mira uye tangazve sevha kuti uone kuti chero shanduko kumatafura ehurongwa hunoitika.
Matafura ese akatariswa uye akagadziridzwa akanyorwa neazvino MySQL vhezheni nhamba.Izvi zvinovimbisa kuti nguva inotevera mysql_upgrade inoshandiswa pane imwechete shanduro yevhavha, inogona kutaura kana tafura ichida kuongororwa kana kugadziriswa zvakare.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) yakagoverwa "BACKWPUP plugin yambiro-haigoni-kutakura-kubva-mysqlproc-the-table-is-probably-corrupt", iyo inobatsira kwauri.
Welcome to share link yechinyorwa chino:https://www.chenweiliang.com/cwl-167.html
Tikugashirei kuTeregiramu chiteshi cheChen Weiliang's blog kuti uwane zvichangobva kuitika!
📚 Iri gwara rine kukosha kukuru, 🌟Uyu mukana usingawanzo, usapotsa! ⏰⌛💨
Govera uye like kana uchida!
Kugovera kwako uye kuda ndiko kukurudzira kwedu kunoramba kuripo!