8

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?

HopelessN00b
  • 53,795
  • 33
  • 135
  • 209
TechplexEngineer
  • 255
  • 1
  • 3
  • 7

1 Answers1

10

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 :-)

famousgarkin
  • 349
  • 4
  • 13
johnshen64
  • 5,865
  • 24
  • 17