刚开始学习使用xtrabackp的恢复,在启动的时候报错
/etc/init.d/mysqld start
Starting MySQL..The server quit without updating PID file ([FAILED]tion/mysql/data/localhost.localdomain.pid)
查看mysql的错误日志
发现有报错
[ERROR] Event Scheduler: Failed to open table mysql.event
[ERROR] Event Scheduler: Error while loading from disk.
[Note] Event Scheduler: Purging the queue. 0 events
[ERROR] Aborting
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 284877836
[Note] /application/mysql/bin/mysqld: Shutdown complete
mysqld_safe mysqld from pid file /application/mysql/data/localhost.localdomain.pid ended
发现说不能打开表,在mysql的数据目录修改权限,在启动还是报相同的错
没有办法 ,只能百度 ,找了一圈,发现一种方法:
在mysql的参数文件中添加参数 “event_scheduler=DISABLED”,重启mysql,达到屏蔽该新功能。
发现数据库可以启动,原因暂时未知