Tlhokomeliso ea plugin ea BACKWPUP-ha e khone ho kenya-ho tloha-mysqlproc-the-tafole-mohlomong-e senyehile

Tlhokomeliso ea plugin ea BACKWPUP-ha e khone ho kenya-ho tloha-MySQLproc-tafole-mohlomong-bobodu

WAARSCHUWING: Databasefout Ha e khone ho kenya ho tloha MySQL.proc.

Temoso ee e tebile hakae?Ho ka etsoa eng ho e lokisa?

Sena se bakoa ke liphetoho tsa schema tse hlokoang ke mefuta e fapaneng ea li-server tsa MySQL.Tsela e bonolo ea ho lokisa sena ke ho tsamaisa taelo ea mysql_upgrade ho tloha molaong oa taelo.

Mabapi le mysql_upgrade

mysql_upgrade e hlahloba litafole tsohle litsing tsohle tsa polokelo bakeng sa ho se lumellane le mofuta oa hajoale oa seva ea MySQL. mysql_upgrade e boetse e ntlafatsa litafole tsa sistimi e le hore ho ka sebelisoa litokelo tse ncha kapa likarolo tseo e kanna eaba li kentsoe.

mysql_upgrade e lokela ho etsoa nako le nako ha MySQL e ntlafatsoa.E nkela sebaka sa khale sa mysql_fix_privilege_tables script, se seng se sa lokela ho sebelisoa.

mysql_upgrade e fana ka litaelo tse latelang ho hlahloba le ho lokisa litafole le ho ntlafatsa litafole tsa tsamaiso:

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

mysql fix_priv_tables

Matha mysql_upgrade ho tloha molaong oa taelo

Ho sebelisa mysql_upgrade, etsa bonnete ba hore seva sa MySQL se ntse se sebetsa, ebe u kopa mysql_upgrade ho sesebelisoa sa mola oa taelo:

mysql_upgrade -uroot -p --force

U lokela ho botsoa hore u fumane phasewete bakeng sa motso oa MySQL, 'me mysql_upgrade e tla hlahloba li-database tsohle le litafole le ho lokisa moo ho loketseng.

U ka 'na ua hloka ho hlalosa tsela e feletseng ea taelo e ka holimo haeba e se tseleng ea ho batla ea khetla.

Ho Debian 6, e lokela ho ba ho:

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

Ho MAMP bakeng sa Mac, tsela ea kamehla ke:

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

Ho Windows, MySQL e tla kenngoa 'me e kenyelelitsoe ho subdirectory ea bin.Ka ho sa feleng e lokela ho ba ho:

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

Qetella!

Kamora ho matha mysql_upgrade, emisa 'me u qale seva hape ho netefatsa hore liphetoho life kapa life litafoleng tsa sistimi lia sebetsa.

Litafole tsohle tse hlahlobiloeng le tse lokisoang li tšoailoe ka nomoro ea hajoale ea mofuta oa MySQL.Sena se tiisa hore nakong e tlang mysql_upgrade e tsamaisoa ka mofuta o tšoanang oa seva, e ka bolela hore na tafole e hloka ho hlahlojoa kapa ho lokisoa hape.