mysqldump all databases returns error

sahostking

• August 07, 2019 17:36

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:

• 

  Henry Carter

  • August 08, 2019 09:00

  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;

  0
• 

  cPanelLauren

  • August 09, 2019 15:06

  The thread here: and the documentation here: both detail this issue.

  0

Please sign in to leave a comment.