BACKWPUP plugin ceeb toom-tsis tuaj yeem-load-ntawm-mysqlproc-the-table-yog-tej zaum-corrupt

BACKWPUP plugin ceeb toom-cannot-load-los ntawm-mysqlproc-the-table-yog-tej zaum-corrupt

WAARSCHUWING: Databasefout Tsis tuaj yeem thauj khoom los ntawm mysql.proc.

Qhov kev ceeb toom no hnyav npaum li cas?Yuav ua li cas kho nws?

Qhov no yog vim qhov kev hloov pauv uas xav tau los ntawm MySQL server sib txawv.Ib txoj hauv kev yooj yim los kho qhov no yog khiav mysql_upgrade hais kom ua los ntawm kab hais kom ua.

Hais txog mysql_upgrade

mysql_upgrade tshawb xyuas tag nrho cov ntxhuav hauv tag nrho cov databases rau incompatibility nrog tam sim no version ntawm MySQL server. mysql_upgrade kuj hloov kho cov rooj sib tham kom cov cai tshiab lossis cov yam ntxwv uas tau ntxiv tuaj yeem siv tau.

mysql_upgrade yuav tsum tau ua txhua zaus MySQL hloov kho.Nws hloov cov ntawv qub mysql_fix_privilege_tables, uas yuav tsum tsis txhob siv lawm.

mysql_upgrade executes cov lus txib hauv qab no los xyuas thiab kho cov ntxhuav thiab txhim kho cov kab ke:

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

mysql fix_priv_tables

Khiav mysql_upgrade los ntawm kab hais kom ua

Txhawm rau siv mysql_upgrade, nco ntsoov tias MySQL server tab tom ua haujlwm, tom qab ntawd hu mysql_upgrade los ntawm cov cuab yeej hais kom ua:

mysql_upgrade -uroot -p --force

Tom qab ntawd koj yuav tsum tau ceeb toom rau tus password rau MySQL hauv paus, thiab mysql_upgrade yuav xyuas tag nrho cov databases thiab cov ntxhuav thiab kho qhov tsim nyog.

Tej zaum koj yuav tau qhia tag nrho txoj hauv kev rau cov lus txib saum toj no yog tias nws tsis nyob hauv lub plhaub txoj kev tshawb nrhiav.

Ntawm Debian 6, nws yuav tsum nyob hauv:

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

Ntawm MAMP rau Mac, txoj hauv kev yog:

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

Ntawm Windows, MySQL yuav raug teeb tsa thiab suav nrog rau hauv cov npe subdirectory.Los ntawm lub neej ntawd nws yuav tsum nyob ntawm:

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

Ua kom tiav!

Tom qab khiav mysql_upgrade, nres thiab rov pib dua lub server kom ntseeg tau tias txhua qhov kev hloov pauv rau cov rooj kaw lus siv tau.

Txhua lub rooj tshuaj xyuas thiab kho tau raug cim nrog MySQL version tus naj npawb tam sim no.Qhov no ua kom ntseeg tau tias lub sijhawm tom ntej mysql_upgrade yog khiav ntawm tib lub version ntawm lub server, nws tuaj yeem qhia tau tias lub rooj yuav tsum tau kuaj xyuas lossis kho dua.