Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.
Sign up to join this community
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?
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 :-)
