MySQL:未知的表引擎 'PERFORMANCE_SCHEMA'

Question

我执行了mysqldump --all-databases，然后从我的 RD Linux 中删除了 MySQL 5.5，然后安装了 MySQL 5.1.73之后，我将所有数据库导入到新服务器，但我的复制服务器未启动，因为存在问题:在主服务器上运行命令 mysql_upgrade 后出现错误:

    Repairing tables
performance_schema.cond_instances
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.events_waits_current
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.events_waits_history
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.events_waits_history_long
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.events_waits_summary_by_instance
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.events_waits_summary_by_thread_by_event_name
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.events_waits_summary_global_by_event_name
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.file_instances
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.file_summary_by_event_name
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.file_summary_by_instance
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.mutex_instances
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.performance_timers
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.rwlock_instances
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.setup_consumers
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.setup_instruments
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.setup_timers
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
performance_schema.threads
Error    : Unknown table engine 'PERFORMANCE_SCHEMA'
error    : Corrupt
Running 'mysql_fix_privilege_tables'...
ERROR 29 (HY000) at line 349: File '/var/log/general.log' not found (Errcode: 13                                                                              )
FATAL ERROR: Upgrade failed

我找不到解决此问题的解决方案，希望您能告诉我方法。

Answer 1

在主服务器上删除 PERFORMANCE_SCHEMA，再次执行 mysqldump，导入到复制服务器，启动 - 确定