BACKWPUP iplagi isilumkiso-ayikwazi-kulayisha-ukusuka-mysqlproc-itheyibhile-mhlawumbi-yonakele

BACKWPUP iplagi isilumkiso-ayikwazi-kulayisha-ukusuka-mysqliproc-itheyibhile-mhlawumbi-yonakele

I-WAARSCHUWING: I-Databasefout Ayinakulayisha ukusuka mysql.proc.

Sibaluleke kangakanani esi silumkiso? Yintoni enokwenziwa ukuyilungisa?

Oku kungenxa yotshintsho lweschema olufunwa ziinguqulelo ezahlukeneyo zeseva yeMySQL. Indlela elula yokusombulula le ngxaki kukusebenzisa mysql_upgrade umyalelo kumgca womyalelo.

Malunga mysql_upgrade

i-mysql_upgrade ijonga zonke iitafile kuzo zonke ii-database zokungahambelani noguqulelo lwangoku lomncedisi we-MySQL. mysql_upgrade iphinda iphucule iitafile zesistim ukuze ukwazi ukuthatha ithuba lamalungelo amatsha okanye umsebenzi onokuthi wongezwe.

mysql_upgrade kufuneka iqhutywe ngalo lonke ixesha iMySQL iphuculwa. Ithatha indawo yeskripthi esidala se-mysql_fix_privilege_tables, esingasasetyenziswa.

mysql_upgrade yenza le miyalelo ilandelayo ukujonga kunye nokulungisa iitafile kunye nokuphucula iitafile zesistim:

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

mysql fix_priv_tables

Qhuba mysql_upgrade ukusuka kumgca womyalelo

Ukusebenzisa mysql_upgrade, qinisekisa ukuba iseva yeMySQL iyasebenza, emva koko ufowunele mysql_upgrade kwisixhobo somyalelo womyalelo:

mysql_upgrade -uroot -p --force

Emva koko kufuneka uxelelwe igama eligqithisiweyo lengcambu ye-MySQL, kwaye i-mysql_upgrade iya kukhangela zonke iinkcukacha kunye neetafile kwaye wenze ukulungiswa apho kufanelekileyo.

Kusenokufuneka uchaze umendo opheleleyo kulo myalelo ungasentla ukuba awukho kumendo wokukhangela weqokobhe.

Kwi-Debian 6, kufuneka ibe ku:

/usr/bin/mysql_upgrade -uroot -p --force

Kwi-MAMP yeMac, indlela engagqibekanga yile:

/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force

Kwi-Windows, i-MySQL iya kufakwa kwaye ifakwe kwi-bin subdirectory. Ngokungagqibekanga kufuneka ibekwe:

"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown

Gqiba!

Emva kokuqhuba i-mysql_upgrade, yeka iseva kwaye uyiqalise kwakhona ukuze uqinisekise ukuba naluphi na utshintsho kwiitafile zenkqubo lusebenza.

Zonke iitafile ezikhangelweyo nezilungisiweyo ziphawulwe ngenombolo yenguqulo yeMySQL yangoku. Oku kuqinisekisa ukuba kwixesha elizayo i-mysql_upgrade iqhutywe kwinguqu efanayo yomncedisi, inokuxelela ukuba itafile kufuneka ihlolwe kwakhona okanye ilungiswe.