mysqldump all databases returns error

sahostking

Well-Known Member
May 15, 2012
389
16
68
Cape Town, South Africa
cPanel Access Level
Root Administrator
Twitter
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

Active Member
Jul 31, 2019
35
6
8
India
cPanel Access Level
Website Owner
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;
 
  • Like
Reactions: kernow

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,272
313
Houston