Comments - Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)

8 years, 4 months ago Matthew Lewis

I'm making some progress but still hitting a brick walls.

mysql -uroot -f < mysql_system_tables_fix.sql syntax didn't work. I got some progress after modifying the command to

mysql -uroot -p -f < mysql_system_tables_fix.sql

Even then, I suspect may not have the correct mysql_system_tables_fix.sql file as I got a bunch of ERROR 1064 (42000) errors.

I found a copy of mysql_system_tables_fix.sql at https://github.com/twitter/mysql/blob/master/scripts/mysql_system_tables_fix.sql. It seems to be for 5.5.40; would the difference between this and 5.5.44.002 make a significant difference? Where else can I for mysql_system_tables_fix.sql files?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.