首页 > 其他 > 详细

[bug] Cannot proceed because system tables used by Event Scheduler were found damaged at server start

时间:2017-04-26 14:09:38      阅读:711      评论:0      收藏:0      [点我收藏+]

本地:mac 10.12.3  mysql 5.6

远程:linux 7.3    mysql 5.7.18.  (远程数据库yum安装,又5.6升级到5.7)

步骤:从本地数据库导出数据到远程数据库

现象:表,存储过程都可以同步过去,

当执行:show events ;

出现

Cannot proceed because system tables used by Event Scheduler were found damaged at server start

 

原因:5.6升级到5.7的时候,数据库配置表的结构发生了一些变化(事件相关)

解决方法:

1.退出mysql,进入shell环境

2.mysql_upgrade -uaccount -ppassword. (升级表结构)

3.systemctl restart mysqld (重启mysqld服务器)

 

[bug] Cannot proceed because system tables used by Event Scheduler were found damaged at server start

原文:http://www.cnblogs.com/china-flint/p/6768166.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!