开发者社区> 问答> 正文

perconna xtrabackup 全备mysql5.5还原到5.6上报错?报错

2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50518, now running 50628. Please use mysql_upgrade to fix this error.
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2017-01-17 16:21:10 8154 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2017-01-17 16:21:10 8154 [Note] Event Scheduler: Loaded 0 events
2017-01-17 16:21:10 8154 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.28'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)

展开
收起
爱吃鱼的程序员 2020-06-08 17:38:22 497 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB
    你看错误信息,performance_schema表你用5.6的吧。5.6默认不就是这个结构么

    Pleaseusemysql_upgradetofixthiserror.

    MySQL起来后,运行mysql_upgrade命令升级一下。然后重启即可。

    用percona备份出来的数据大版本升级的时候需要升级一下。

    2020-06-08 17:38:37
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像