iT邦幫忙

0

mysql8 upgrade table is probably corrupted

  • 分享至 

  • xImage

將mysql5的備份倒到8版
發現phpmyadmin有舊sql的帳號
要刪除帳號出錯誤
#1728 - Cannot load from mysql.db. The table is probably corrupted #1728 - Cannot load from mysql.db. The table is probably corrupted

查了一下資料8已經不支援Myisam
可能有些步驟沒有做到
直接在本機執行mysqlupgrade
又跳出其他錯誤 這問題有沒有解?

The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.
圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

1 個回答

0
ckp6250
iT邦好手 1 級 ‧ 2019-11-29 20:16:04

您是怎麼由 5 備份到 8 的?

hsiang11 iT邦好手 1 級 ‧ 2019-11-29 23:31:33 檢舉

將備份檔還原到8

ckp6250 iT邦好手 1 級 ‧ 2019-11-30 09:41:39 檢舉

先假設最壞的情況,若這問題沒有解,
您會怎樣?
看破紅塵,削髮為僧?

我要發表回答

立即登入回答