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

7 years, 5 months ago Matthew Lewis

Hi.

Thanks for your assistance.

I've done a search for "uroot" and "mysql_system_tables_fix.sql" in an attempt to gain some understanding around what is going on. I was unable to find anything at the MySQL website and a web search for "mysql_system_tables_fix" for MariaDB 5.5.44 just got me confused with the GitHubs, bugs.debians and dev.mysqls!

How safe is using one of the files from these websites? Do I have to use a "mysql_system_tables_fix" that is built specifically for version 5.5.44.002 or will 5.5.44 or even 5.5 suffice? Can you suggest a safe website where I can download the file?

Thanks for helping a complete beginner!

 
7 years, 5 months ago Sergei Golubchik

-uroot is a shorter form of --user=root, means mysql will connect as a root user. mysql_system_tables_fix.sql is, basically, the set of SQL commands that mysql_upgrade runs. So, I said that if you don't have mysql_upgrade you can run this set of commands manually, using the mysql command-line client.

 
7 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.