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

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to