maria-discuss team mailing list archive

[Frank Röhm <francwalter@xxxxxxx>]

Hello

day before yesterday I updated my MySQL Server 5.5.34 to MariaDB 5.5.34
on my Ubuntu 12.04 Server.

All went fine but next day, I noticed that the automatic backup script
(automysqlbackup) had errors, I read:

mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM
`EVENTS`': Cannot proceed because system tables used by Event Scheduler
were found damaged at server start (1577)
mysqldump: Couldn't execute 'show events': Cannot proceed because system
tables used by Event Scheduler were found damaged at server start (1577)

I searched about it and found the hint to do the command mysql_upgrade
(I needed the option --force) and restart the server.
This didn't help, no change.

When I manually select * from EVENTS from information_schema I get the
same error 1577.

When I upgraded I made a backup before, so could I just overwrite the
existing information_schema with the dump from my backup?
Could I destroy something?

Thank you.

frank