Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just noticed the following error from my old mysql backup scripts:

% mysqldump -hsql -uXXXX -pXXXX --events --all-databases > /dev/null 
mysqldump: Couldn't execute 'show events': Cannot proceed because system tables
     used by Event Scheduler were found damaged at server start (1577)

Poking around seems to indicate some sort of corruption with mysql.events (I can dump without errors if I skip the --events flag). I'm worried that something's seriously wrong with the database and can't fine any clear instance of someone reporting the same problem. Closest match seems to indicate that myisamchk should be used to rebuild the ISA index, but I'm not convinced it's the same problem.

I'm running mysql v14.14 on an ubuntu 10.04.4 LTS system. Other than this error, I'm not seeing any other symptoms/problems.

I was hoping someone could provide some advice before I start poking around and risk really corrupting the db.

share|improve this question
up vote 7 down vote accepted

Sounds like a broken mysql upgrade.

I would suggest to try :

mysql_upgrade -u root -h localhost -p --verbose --force

and then /etc/init.d/mysql restart

Finally, try again :)

share|improve this answer
    
Worked for me. Thanks. – Sinan Eldem Nov 11 '15 at 16:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.