BACKWPUP plugin digniin-ka-soo-rarsan kara-mysqlproc-miiska-malaha-waa musuqmaasuq

BACKWPUP plugin digniin-ka-soo degi karo-MySQLProc-the-miiska-malaha-waa musuqmaasuq

WAARSCHUWING: Databasefout Lagama soo rari karo MySQL.proc.

Intee bay halis tahay digniintan?Maxaa lagu hagaajin karaa?

Tan waxa u sabab ah isbeddellada schema ee ay u baahan yihiin noocyada kala duwan ee server MySQL.Habka ugu fudud ee tan lagu hagaajin karo waa in laga socodsiiyo amarka mysql_upgrade ee khadka taliska.

Ku saabsan mysql_upgrade

mysql_upgrade waxay hubisaa dhammaan jaantusyada ku jira kaydka xogta oo dhan si aanay ula socon nooca hadda ee server-ka MySQL. mysql_upgrade sidoo kale waxay cusboonaysiisaa miisaska nidaamka si mudnaanta ama sifooyinka cusub ee lagu soo daray looga faa'iidaysan karo.

mysql_upgrade waa in la fuliyaa mar kasta oo MySQL la cusboonaysiiyo.Waxay bedeshaa qoraalkii hore ee mysql_fix_privilege_tables, kaas oo ay tahay inaan mar dambe la isticmaalin.

mysql_upgrade waxay fulisaa amarada soo socda si loo hubiyo loona hagaajiyo miisaska iyo cusboonaysiinta miisaska nidaamka:

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

mysql fix_priv_tables

Ka socodsii mysql_upgrade khadka taliska

Si aad u isticmaasho mysql_upgrade, hubi in server-ka MySQL uu socdo, ka dibna ka wac mysql_upgrade qalabka khadka taliska:

mysql_upgrade -uroot -p --force

Markaa waa in lagugu soo jeediyo furaha sirta ah ee xidid MySQL, iyo mysql_upgrade waxay hubin doontaa dhammaan xogta iyo miisaska iyo hagaajinta meesha ku habboon.

Waxaa laga yaabaa inaad u baahato inaad qeexdo dariiqa buuxa ee amarka kore haddii aysan ku jirin jidka raadinta qolofka.

Debian 6, waa inay ku jirtaa:

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

Dhanka MAMP ee Mac, dariiqa caadiga ah waa:

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

Daaqadaha, MySQL ayaa lagu rakibi doonaa waxaana lagu dari doonaa hagaha-hoosaadka.Sida caadiga ah waa inay ku taal:

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

Dhammee!

Kadib socodsiinta mysql_upgrade, jooji oo dib u bilow seerfarka si aad u hubiso in isbedel kasta oo lagu sameeyo miisaska nidaamka uu hirgalo.

Dhammaan miisaska la hubiyay iyo kuwa la dayactiray waxaa lagu calaamadeeyay lambarka MySQL ee hadda jira.Tani waxay hubinaysaa in marka xigta mysql_upgrade lagu shaqeeyo isla nooca server-ka, waxay sheegi kartaa haddii miiska loo baahan yahay in la hubiyo ama dib loo hagaajiyo.