Uhla lwemibhalo ye-athikili
Isexwayiso se-plugin ye-BACKWPUP-ayikwazi-ukulayisha-isuka-mysqli-proc-the-table-cishe-yonakele
WAARSCHUWING: I-databasefout Ayikwazi ukulayisha ukusuka mysql.proc.
Sibucayi kangakanani lesi sixwayiso?Yini engenziwa ukuze kulungiswe?
Lokhu kungenxa yezinguquko ze-schema ezidingwa izinguqulo ezihlukile zeseva ye-MySQL.Indlela elula yokulungisa lokhu ukusebenzisa umyalo we-mysql_upgrade usuka kulayini womyalo.
Mayelana ne-mysql_upgrade
mysql_upgrade ihlola wonke amathebula kuzo zonke izingosi zolwazi ukuze angahambisani nenguqulo yamanje yeseva ye-MySQL. mysql_upgrade iphinde ithuthukise amathebula esistimu ukuze kusetshenziswe amalungelo amasha noma izici okungenzeka zengeziwe.
mysql_upgrade kufanele yenziwe njalo lapho i-MySQL ithuthukiswa.Ingena esikhundleni seskripthi esidala se-mysql_fix_privilege_tables, okungafanele sisasetshenziswa.
mysql_upgrade ikhipha imiyalo elandelayo ukuhlola nokulungisa amatafula nokuthuthukisa amatafula esistimu:
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql fix_priv_tables
Qalisa mysql_upgrade kusuka kulayini womyalo
Ukuze usebenzise i-mysql_upgrade, qiniseka ukuthi iseva ye-MySQL iyasebenza, bese ucela i-mysql_upgrade ethuluzini lomugqa womyalo:
mysql_upgrade -uroot -p --force
Ngemuva kwalokho kufanele utshelwe iphasiwedi yempande ye-MySQL, futhi i-mysql_upgrade izohlola yonke imininingwane yolwazi namatafula futhi ilungise lapho kufanele khona.
Ungase udinge ukucacisa indlela egcwele yomyalo ongenhla uma ingekho endleleni yokusesha yegobolondo.
Ku-Debian 6, kufanele ibe ku:
/usr/bin/mysql_upgrade -uroot -p --force
Ku-MAMP ye-Mac, indlela ezenzakalelayo ithi:
/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force
Ku-Windows, i-MySQL izofakwa futhi ifakwe ohlwini olungaphansi lomgqomo.Ngokuzenzakalelayo kufanele ibe ku:
"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown
Qeda!
Ngemva kokusebenzisa mysql_upgrade, yima futhi uqale kabusha iseva ukuze uqinisekise ukuthi noma yiziphi izinguquko kumathebula esistimu ziyasebenza.
Wonke amatafula ahloliwe nalungiswa amakwe ngenombolo yamanje yenguqulo ye-MySQL.Lokhu kuqinisekisa ukuthi ngesikhathi esilandelayo mysql_upgrade is run on the same version of the server, it can tell uma ithebula lidinga ukuhlolwa noma ukulungiswa futhi.
I-Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwene "Isixwayiso se-plugin BACKWPUP- cannot-load-from-mysqlproc-the-table-is-probably-corrupt", okuwusizo kuwe.
Siyakwamukela ukwabelana ngesixhumanisi salesi sihloko:https://www.chenweiliang.com/cwl-167.html