BACKWPUP plugin yambiro-haigone-kurodha-kubva-mysqlproc-iyo-tafura-ine-zvichida-yaora

Yambiro yeBACKWUP plugin-haigone kurodha-kubva- mysql proc-the-table-ingangove-yakashata

WAARSCHUWING: Databasefout Haikwanisi kurodha kubva kumysql .proc.

Yambiro iyi yakakomba sei?Chii chingaitwa kugadzirisa?

Izvi zvinokonzerwa nekuchinja kwe schema kunodiwa nemhando dzakasiyana dzeMySQL server.Nzira iri nyore yekugadzirisa iyi ndeyekumhanyisa mysql_upgrade command kubva kumutsara wekuraira.

Nezve mysql_upgrade

mysql_upgrade inotarisa matafura ese mune ese dhatabhesi kuti asaenderane neyazvino vhezheni yeMySQL server. mysql_upgrade zvakare inokwidziridza matafura ehurongwa kuitira kuti maropafadzo matsva kana maficha angave akawedzerwa anogona kushandiswa.

mysql_upgrade inofanira kuitwa nguva dzose MySQL painokwidziridzwa.Inotsiva yekare mysql_fix_privilege_tables script, iyo isingachafanira kushandiswa.

mysql_upgrade inoita iyo inotevera mirairo yekutarisa uye kugadzirisa matafura uye kukwidziridza system matafura:

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

mysql fix_priv_tables

Mhanya mysql_upgrade kubva pamutsetse wekuraira

Kuti ushandise mysql_upgrade, ita shuwa kuti MySQL server iri kushanda, wobva wadaidza mysql_upgrade kubva kune yekuraira mutsara chishandiso:

mysql_upgrade -uroot -p --force

Iwe unofanirwa kubva wakumbirwa password yeMySQL mudzi, uye mysql_upgrade inotarisa ese dhatabhesi uye matafura uye kugadzirisa pazvinenge zvakakodzera.

Ungangoda kutsanangura nzira izere yekuraira iri pamusoro kana isiri munzira yekutsvaga yegoko.

PaDebian 6, inofanirwa kunge iri mu:

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

PaMAMP yeMac, iyo yakasarudzika nzira ndeye:

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

PaWindows, MySQL ichaiswa uye inosanganisirwa mubhini subdirectory.By default inofanira kunge iri pa:

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

Finish!

Mushure mekuita mysql_upgrade, mira uye tangazve sevha kuti uone kuti chero shanduko kumatafura ehurongwa hunoitika.

Matafura ese akatariswa uye akagadziridzwa akanyorwa neazvino MySQL vhezheni nhamba.Izvi zvinovimbisa kuti nguva inotevera mysql_upgrade inoshandiswa pane imwechete shanduro yevhavha, inogona kutaura kana tafura ichida kuongororwa kana kugadziriswa zvakare.