Failed to Backup Deleted Tables

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)

Hello,

Thank you for your message.

If possible, try using the --ignore-table option in mysqldump to exclude the invalid views from your backup. You can add all the tables you want to exclude in the “Extra command line parameters” field under Backup options.

Please refer to the screenshot below for guidance.