Couldn't execute 'show events' 15777

Question

After spending days for looking for a solution, I'm taking my chance here. I have a MySQL server that I try to backup with the following command :

mysqldump -p --all-databases --allow-keywords --master-data --events --single-transaction 
   -u root > /root/mysqldump.sql

When I'm doing this, I have this answer :

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

I have try to do a mysql_upgrade -u root -h localhost -p --verbose --force everything look OK but the mysqldump still not working with the same error.

Can you help me please ?

Answer 1

I had the same problem, but the mysql_dump worked fine despite those warnings. I use Mariadb Ver 15.1 Distrib 10.3.22-MariaDB, for debian.

Your command fixed the error:

mysql_upgrade -u root -h localhost -p --verbose --force

Update: I had the same error after migrating the server to a new mashine, I guess, because I used rsync for the database files and no mysqldump. The command also fixed the error again on Debian stretch with Mariadb Ver 15.1 Distrib 10.1.44-MariaDB