The full error message is like:

“Oops, The restoration seems to have encountered a problem:(
Please adjust the advanced settings before restoring and retry. Read more…
Error Info:An exception has occurred. class: PDOException;msg: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation;code: 42000;line: 334;in_file: /var/www/abc.com/htdocs/wp-content/plugins/wpvivid-backup-pro/addons2/backup_pro/class-wpvivid-restore-db-method-addon.php;”
This is usually a database permission issue with PDO method, and this guide can help fix it.
Or, you can ignore it and use the ‘WPDB’ method to run the restore as shown below: