mysql_upgrade --force,MySQL force upgrade

红太狼 2023-01-14 04:58 20阅读 0赞

![f690b1cc60d51e1e6ff501475480e805.gif][]

奇怪我的 MySQL 很容易當掉,然後我的 http://Benjr.tw 就會直接在網頁上顯示資料庫連線錯誤,檢查 /var/log/mysql 裡面的 log 會顯示 table 錯誤.

root@benjr:~\# cat /var/log/mysql.log

root@benjr:~\# cat /var/log/mysql.err

root@benjr:~\# cat /var/log//mysql/error.log

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './benjr/wp\_commentmeta' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './benjr/wp\_commentmeta'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './benjr/wp\_comments' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './benjr/wp\_comments'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './benjr/wp\_options' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './benjr/wp\_options'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './benjr/wp\_postmeta' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './benjr/wp\_postmeta'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './benjr/wp\_posts' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './benjr/wp\_posts'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './benjr/wp\_usermeta' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './benjr/wp\_usermeta'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './radytobe/wp\_options' is marked as crashed and should be repaired

160323 5:24:20 \[Warning\] Checking table: './radytobe/wp\_options'

160323 5:24:20 \[ERROR\] /usr/sbin/mysqld: Table './radytobe/wp\_postmeta' is marked as crashed and should be repaired

用下面的指令就可以修復.

root@benjr:~\# initctl stop mysqld

root@benjr:~\# cd /var/lib/mysql/drupal

root@benjr:~\# myisamchk –r \*.MYI

root@benjr:~\# initctl start mysqld

整理完之後就可以,但過一段時間 MySQL 又會有錯誤產生.後來檢查到 /var/log/syslog 裡面有一段關於 MySQL 的錯誤訊息 “Upgrading MySQL tables if necessary.”.

root@benjr.tw:~\# cat /var/log/syslog

Mar 23 05:24:19 benjr.tw /etc/mysql/debian-start\[427\]: Upgrading MySQL tables if necessary.

Mar 23 05:24:19 benjr.tw /etc/mysql/debian-start\[430\]: /usr/bin/mysql\_upgrade: the '--basedir' option is always ignored

Mar 23 05:24:19 benjr.tw /etc/mysql/debian-start\[430\]: Looking for 'mysql' as: /usr/bin/mysql

Mar 23 05:24:19 benjr.tw /etc/mysql/debian-start\[430\]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck

Mar 23 05:24:19 benjr.tw /etc/mysql/debian-start\[430\]: This installation of MySQL is already upgraded to 5.5.47, use --force if you still need to run mysql\_upgrade

似乎需要下下面的指令來更新 MySQL

root@benjr.tw:/var/log\# mysql\_upgrade -u root -p

Enter password:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

This installation of MySQL is already upgraded to 5.5.47, use --force if you still need to run mysql\_upgrade

要加上 參數 force 才能使用.更新之後看起來一些怪問題都解決了,但 MYSQL 會不會再發生當掉的問題還需要在觀察一段時間.

root@benjr.tw:/var/log\# mysql\_upgrade --force -u root -p

Enter password:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'

benjr.wp\_commentmeta OK

benjr.wp\_comments OK

benjr.wp\_links OK

benjr.wp\_options OK

benjr.wp\_postmeta OK

benjr.wp\_posts OK

benjr.wp\_term\_relationships OK

benjr.wp\_term\_taxonomy OK

benjr.wp\_termmeta OK

benjr.wp\_terms OK

benjr.wp\_usermeta OK

benjr.wp\_users OK

benjr.wp\_wp\_rp\_tags OK

benjr.wp\_commentmeta OK

benjr.wp\_comments OK

benjr.wp\_links OK

benjr.wp\_options OK

benjr.wp\_postmeta OK

benjr.wp\_posts OK

benjr.wp\_postviews\_plus OK

benjr.wp\_term\_relationships OK

benjr.wp\_term\_taxonomy OK

benjr.wp\_termmeta OK

benjr.wp\_terms OK

benjr.wp\_usermeta OK

benjr.wp\_users OK

benjr.wp\_wp\_rp\_tags OK

Running 'mysql\_fix\_privilege\_tables'...

root@benjr:~\# initctl restart mysqld

冏,上星期還是發生過一次 MySQL 整個當掉的問題!!

沒有解決問題,試試搜尋本站其他內容

[f690b1cc60d51e1e6ff501475480e805.gif]: /images/20221022/891538afb69d44a88febcfe5ae805e58.png

mysql_upgrade --force,MySQL force upgrade

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 React Native Upgrade

相关 Ubuntu 源管理 && update upgrade dist-upgrade 区别

相关 mysql_upgrade --force,MySQL force upgrade

相关 Teacher Forcing技术

相关 yarn upgrade 和 yarn upgrade --latest

相关【codeforces】Uncowed Forces

相关 HDFS Rolling Upgrade

相关 MySQL Forcing InnoDB Recovery

相关 yarn upgrade

相关 SharePoint 2013 - Upgrade