mysqldump all databases returns error

[sahostking]

mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES


I googled it a bit and they state this happens with left over parts from mysql to mariadb upgrade which we did awhile ago.

Is it safe to do as stated here:

How to fix the sys.host_summary table in MariaDB 10.3.13

using mysqldump while doing a backup gives the following error: mysqldump: Got error: 1356: "View 'sys.host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of v...

dba.stackexchange.com

 

[Henry Carter]

Hi,

What version of MariaDB you are using and also Yes you can take a backup of all files and safely drop the database "sys" by following commands.

DROP DATABASE sys;

 

[cPanelLauren]

The thread here: New Thread - mysqldump all databases returns error and the documentation here: MySQL or MariaDB Upgrade - Version 82 Documentation - cPanel Documentation both detail this issue.