Isexwayiso se-plugin Eyisipele-asikwazi-ukulayishwa-kusuka-mysqlproc-ithebula-cishe-yonakele

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.