首页 > 数据库 >mysql入坑之路(9)Navicat导出SQL数据报错1577 - Cannot proceed because system tables used by Event Scheduler were

mysql入坑之路(9)Navicat导出SQL数据报错1577 - Cannot proceed because system tables used by Event Scheduler were

时间:2022-09-19 14:33:22浏览次数:135  
标签:tables because 报错 Scheduler mysql Event

参考文档:
https://blog.csdn.net/phpfenghuo/article/details/40537477

报错信息

[DTF] 0> Getting events
[ERR] 0> 1577 - Cannot proceed because system tables used by Event Scheduler were found damaged at server start
[DTF] Process terminated

naivcat客户端报错:

命令行查看报错:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bpmx               |
| imsrun             |
| mick3310           |
| mysql              |
| performance_schema |
| plancp             |
| project_manage     |
+--------------------+
8 rows in set (0.00 sec)

mysql> use bpmx;
Database changed
mysql> show events;
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
mysql> show variables like 'event_scheduler';
+-----------------+----------+
| Variable_name   | Value    |
+-----------------+----------+
| event_scheduler | DISABLED |
+-----------------+----------+
1 row in set (0.00 sec)

mysql>  select * from mysql.event;
Empty set (0.00 sec)

解决:

原数据库的表版本和现在的数据库版本不一致造成的,需要更新下系统表结构
是现在要导出来的这个表结构和数据库的版本不适配
https://blog.csdn.net/zhh763984017/article/details/107082142/你打开下这个博客

1、启动mysql
mysqld_safe --defaults-file=/old-root/var/lib/mysql4/my.cnf &
2、进入mysql
mysql -uroot -pisunland -S /old-root/var/lib/mysql4/mysql.sock
3、执行mysql_upgrade  语句
/usr/mysql-5.7/bin/mysql_upgrade  -uroot -pisunland -S /old-root/var/lib/mysql5/mysql.sock
4、重启mysql5数据库

标签:tables,because,报错,Scheduler,mysql,Event
From: https://www.cnblogs.com/muzlei/p/16707577.html

相关文章