BACKWPUP plugin gargadi-ba za a iya loda-daga-mysqlproc-the-tebur-wataƙila-lalacewa ne.

BACKWPUP plugin gargadi-ba za a iya loda-daga-MySQLproc-the-tebur-yana-watakila-lalacewa

WAARSCHUWING: Databasefout Ba za a iya lodawa daga MySQL.proc.

Yaya girman wannan gargaɗin yake?Me za a iya yi don gyara shi?

Wannan ya faru ne saboda sauye-sauyen tsari da nau'ikan uwar garken MySQL daban-daban ke buƙata.Hanya mai sauƙi don gyara wannan ita ce gudanar da umarnin mysql_upgrade daga layin umarni.

Game da mysql_upgrade

mysql_upgrade yana duba duk tebur a cikin duk bayanan bayanai don rashin dacewa da sigar uwar garken MySQL na yanzu. mysql_upgrade kuma yana haɓaka tebur na tsarin ta yadda za a iya amfani da sabbin gata ko fasalulluka waɗanda ƙila an ƙara su.

mysql_upgrade yakamata a aiwatar dashi duk lokacin da aka haɓaka MySQL.Yana maye gurbin tsohon rubutun mysql_fix_privilege_tables, wanda bai kamata a ƙara amfani da shi ba.

mysql_upgrade yana aiwatar da waɗannan umarni don dubawa da gyara tebur da haɓaka teburin tsarin:

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

mysql fix_priv_tables

Gudu mysql_upgrade daga layin umarni

Don amfani da mysql_upgrade, tabbatar da uwar garken MySQL yana gudana, sannan ku kira mysql_upgrade daga kayan aikin layin umarni:

mysql_upgrade -uroot -p --force

Sannan ya kamata a sa ku sami kalmar sirri don tushen MySQL, kuma mysql_upgrade zai duba duk bayanan bayanai da tebur kuma a gyara su a inda ya dace.

Kuna iya buƙatar saka cikakken hanyar zuwa umarnin da ke sama idan ba a cikin hanyar neman harsashi ba.

A kan Debian 6, yakamata ya kasance cikin:

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

A kan MAMP don Mac, tsohuwar hanyar ita ce:

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

A kan Windows, za a shigar da MySQL kuma a haɗa su a cikin babban kundin adireshi.Ta hanyar tsoho ya kamata a kasance a:

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

Gama!

Bayan gudanar da mysql_upgrade, dakatar da sake kunna uwar garken don tabbatar da cewa duk wani canje-canje ga teburin tsarin ya fara aiki.

Duk teburin da aka bincika da gyara ana yiwa alama da lambar sigar MySQL ta yanzu.Wannan yana tabbatar da cewa lokaci na gaba na mysql_upgrade yana gudana akan sigar uwar garken iri ɗaya, zai iya sanin ko tebur yana buƙatar sake dubawa ko gyarawa.