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/;”
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:
WPDB Restore WPvivid Backup Pro