Comments - Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
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.
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!
-uroot
is a shorter form of--user=root
, meansmysql
will connect as a root user.mysql_system_tables_fix.sql
is, basically, the set of SQL commands thatmysql_upgrade
runs. So, I said that if you don't havemysql_upgrade
you can run this set of commands manually, using the mysql command-line client.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?