服務器強制重啟導緻MySQL無法啟動報錯信息為:
The server quit without updating PID file(XXX/XXX.pid)
查看mysql日志報錯信息為:
/www/server/mysql/bin/mysqld: Table './mysql/db' is marked as crashed and should be repaired
Fatal error: Can't open and lock privilege tables: Table './mysql/db' is marked as crashed and should be repaired
5.6版本的數據庫為:
myisamchk -rf /www/server/data/mysql/db
其他版本的數據庫為:
myisamchk -rf /www/server/data/mysql/db.MYI
更多精彩资讯请关注tft每日頭條,我们将持续为您更新最新资讯!