Home / server / Questions / 385015
Accepted
TechplexEngineer
Asked: 2012-05-02 11:04:30 +0800 CST

MySQL damaged system tables

  • 772

I ran a query that hung my mysql dameon pretty bad. Still not sure what thats about. When I tried to restart MySQL, I was getting errors that the service could not be stopped, so I killed the process (probably not a good idea in hindsight). When I tried to restart the MySQL service I get:

$ ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start

Any ideas?

mysql event-scheduler

1 Answers

  1. Best Answer

    Go to your MySQL database directory (usually /var/lib/mysql/mysql), and then do a myisamchk to repair all the tables, then try again. It is likely that more than 1 tables were damaged in this case, and you want to fix them all. If you really cannot, you would have to copy it from a backup or an equivalent setup. Please don't say you have no backups :-)

    • 10