maria-discuss team mailing list archive
Mailing list archive
Change from MySQL to MariaDB - Problem with EVENTS-Table in information_schema
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?