MySQL Restore error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
If you run into the "SUPER privilege" when running a MySQL restore, it would be because the restores do not run with a root/super level privilege, for security reasons.
: as of DirectAdmin 1.49.2, you can set an Admin Level restore to run with da_admin to overcome this issue.
The option must be enabled in the directadmin.conf to do this:
If you need to restore a trusted database (sql file) that has items which requires the SUPER level access, then you'd need to do it manually.
Extract the sql file from the backup. Adjust the backup path as needed:
tar xvzf ../user.admin.username.tar.gz backup
which should have the sql file in the directory.
Grab the da_admin user/pass to do the restore with. This is a root level account, so ensure you trust the contents of the SQL file:
Then restore the username_dbname
mysql -uda_admin -ppassword username_dbname < username_dbname.sql
which should get past the above errors.