Backups Failing: …tables used by Event Scheduler were found damaged at server start (1577)

On your MySQL Server doing backups you get:

Backups Failing:   Dumping MySQL database database_name …. dump failed! mysqldump: Couldn’t execute ‘show events’: Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)

Try these repair actions, do one, test, and then do the other one.

mysql_upgrade -u -p

Now test. If that doesn’t work, do this:

mysqlcheck -u -p –all-databases –check-upgrade –auto-repair

To test, use ‘database_name’ and then do ‘show events’.

Reference:

https://serverfault.com/questions/100685/cannot-proceed-because-system-tables-used-by-event-scheduler-were-found-damaged/224487

Tags

Share this article

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top