I have a daily full backup job which started to error after some tables were deleted from the source MySQL database.
The source database belongs to an application which recently received an update. As part of this update, tables were removed from the DB. I have included the error message below.
I have logged into the MySQL database directly and confirmed these tables no longer exist.
I have also tried recreating the job from scratch but I receive the same error.
Does anyone know where the backup software is identifying these redundant tables and how I can stop it from trying to back them up?
Couldn’t execute ‘show fields from plugin_sophos_central_v_allowed_and_blocked’: View ‘labtech.plugin_sophos_central_v_allowed_and_blocked’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn’t execute ‘show fields from plugin_sophos_central_v_detected_exploits’: View ‘labtech.plugin_sophos_central_v_detected_exploits’ referen… execute ‘show fields from plugin_sophos_central_v_scanning_exclusions’: View ‘labtech.plugin_sophos_central_v_scanning_exclusions’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn’t execute ‘show fields from plugin_sophos_central_v_web_control_sites’: View ‘labtech.plugin_sophos_central_v_web_control_sites’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)