Papa Kuhikuhi ʻatikala
BACKWPUP plugin ʻōlelo aʻo-hiki ʻole ke hoʻouka-mai-mysqlproc-the-table-he-pololei paha
WAARSCHUWING: Databasefout ʻAʻole hiki ke hoʻouka mai mysql.proc.
Pehea ke koʻikoʻi o kēia ʻōlelo aʻo?He aha ka hana e hoʻoponopono ai?
Loaʻa kēia ma muli o nā loli schema i koi ʻia e nā mana kikowaena MySQL ʻē aʻe.ʻO kahi ala maʻalahi e hoʻoponopono ai i kēia ka holo ʻana i ke kauoha mysql_upgrade mai ka laina kauoha.
E pili ana i mysql_upgrade
ʻIke ʻo mysql_upgrade i nā papa ʻaina āpau i nā ʻikepili āpau no ka like ʻole me ka mana o kēia manawa o ka server MySQL. Hoʻonui hou ʻo mysql_upgrade i nā papa ʻōnaehana i hiki ke hoʻohana ʻia nā pono hou a i ʻole nā hiʻohiʻona i hoʻohui ʻia.
Pono e hoʻokō ʻia ka mysql_upgrade i kēlā me kēia manawa e hoʻonui ʻia ʻo MySQL.Hoʻololi ia i ka ʻatikala mysql_fix_privilege_tables kahiko, ʻaʻole pono e hoʻohana hou ʻia.
hoʻokō ʻo mysql_upgrade i kēia mau kauoha e nānā a hoʻoponopono i nā papa a hoʻomaikaʻi i nā papa ʻōnaehana:
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql fix_priv_tables
E holo i ka mysql_upgrade mai ka laina kauoha
No ka hoʻohana ʻana i ka mysql_upgrade, e hōʻoia i ka holo ʻana o ka server MySQL, a laila e kāhea i ka mysql_upgrade mai ka mea hana laina kauoha:
mysql_upgrade -uroot -p --force
Pono ʻoe e koi ʻia no kahi ʻōlelo huna no MySQL root, a e nānā ʻo mysql_upgrade i nā ʻikepili āpau a me nā papa a hoʻoponopono i kahi kūpono.
Pono paha ʻoe e kuhikuhi i ke ala piha i ke kauoha ma luna inā ʻaʻole ia ma ke ala huli o ka shell.
Ma Debian 6, pono ia i:
/usr/bin/mysql_upgrade -uroot -p --force
Ma MAMP no Mac, ʻo ke ala paʻamau:
/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force
Ma Windows, e hoʻokomo ʻia ʻo MySQL a hoʻokomo ʻia i loko o ka subdirectory bin.Ma ka paʻamau, pono e loaʻa ma:
"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown
Hoʻopau!
Ma hope o ka holo ʻana i ka mysql_upgrade, hoʻopau a hoʻomaka hou i ke kikowaena e hōʻoia i ka hoʻololi ʻana i nā papa ʻōnaehana.
Ua kaha ʻia nā papa ʻaina a pau i nānā ʻia a hoʻoponopono ʻia me ka helu mana MySQL o kēia manawa.Hōʻoia kēia i ka manawa aʻe e holo ai ka mysql_upgrade ma ka mana like o ke kikowaena, hiki iā ia ke haʻi inā pono e nānā a hoʻoponopono hou ʻia ka papaʻaina.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kaʻana like "BACKWPUP plugin warning-cannot-load-from-mysqlproc-the-table-is-probably-corrupt", he mea kōkua iā ʻoe.
Welina mai e kaʻana like i ka loulou o kēia ʻatikala:https://www.chenweiliang.com/cwl-167.html
Welina mai i ke kahawai Telegram o ka moʻomanaʻo ʻo Chen Weiliang e kiʻi i nā mea hou loa!
📚 He waiwai nui kēia alakaʻi, 🌟He manawa kakaikahi kēia, mai poina! ⏰⌛💨
Kaʻana like a like inā makemake ʻoe!
ʻO kāu kaʻana like a me kou makemake ʻo kā mākou hoʻoikaika mau!