使用 Mysql 5.5 运行共享主机 cpanel 盒。
恢复或打包（使用 pkgacct）对多个不同用户产生了一些严重的数据库错误
sum_joom954.jos_wf_profiles OK
warn [pkgacct] sum_joom954: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'sum_joom954'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] sum_joom954: mysqldump failed -- database may be corrupt
(774188 bytes) warn [pkgacct] Failed to dump database sum_joom954
horde.turba_objectswarn [pkgacct] horde.turba_objects: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.turba_objects OK
warn [pkgacct] horde.turba_objects: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(2761 bytes) warn [pkgacct] Failed to dump database horde
horde.turba_shareswarn [pkgacct] horde.turba_shares: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.turba_shares OK
warn [pkgacct] horde.turba_shares: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1440 bytes) warn [pkgacct] Failed to dump database horde
horde.horde_prefswarn [pkgacct] horde.horde_prefs: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.horde_prefs OK
warn [pkgacct] horde.horde_prefs: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(10240 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_eventswarn [pkgacct] horde.kronolith_events: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.kronolith_events OK
warn [pkgacct] horde.kronolith_events: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1145 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_shareswarn [pkgacct] horde.kronolith_shares: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
.........
horde.kronolith_shares OK
warn [pkgacct] horde.kronolith_shares: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1557 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_shares_userswarn [pkgacct] horde.kronolith_shares_users: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.kronolith_shares_users OK
warn [pkgacct] horde.kronolith_shares_users: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1107 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_storagewarn [pkgacct] horde.kronolith_storage: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.kronolith_storage OK
warn [pkgacct] horde.kronolith_storage: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1123 bytes) warn [pkgacct] Failed to dump database horde
horde.mnemo_memoswarn [pkgacct] horde.mnemo_memos: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.mnemo_memos OK
warn [pkgacct] horde.mnemo_memos: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1101 bytes) warn [pkgacct] Failed to dump database horde
horde.nag_taskswarn [pkgacct] horde.nag_tasks: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
horde.nag_tasks OK
warn [pkgacct] horde.nag_tasks: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)
warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1093 bytes) warn [pkgacct] Failed to dump database horde
ERROR: Failed to dump one or more databases
cpanel 技术人员告诉我：
It looks like a major problem with MySQL right now is that InnoDB is corrupt and was set as disabled, although several databases are using that storage engine. Have you attempted InnoDB recovery on this server?
Due to policy and liability issues, we won't be able to assist with forcing InnoDB recovery. However, the following link should be able to assist you:
http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html
The file that will need to be edited is /etc/my.cnf
有人能用通俗易懂的语言向我解释如何修复这些问题吗？我不确定如何简化数据库。我首先需要知道哪些数据库/表存在此问题。我精通 ssh，所以我可以一步一步理解。
答案1
首先停止数据库并备份所有 mysql 文件 (/var/lib/mysql)。其次启动在控制台上运行的服务器
mysql_upgrade
如果它表示已经升级，请使用强制标志再次运行
mysql_upgrade -f