MySQL:未知表引擎“PERFORMANCE_SCHEMA”

Question

我执行了mysqldump --所有数据库，然后从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，导入复制服务器，启动- ok