|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.|
UPDATE: 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.
1) Extract the sql file from the backup. Adjust the backup path as needed:
2) 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:
3) Then restore the username_dbname.sql file:
mysql -uda_admin -ppassword username_dbname < username_dbname.sqlwhich should get past the above errors.
© 2018 JBMC Software, Suite 173 3-11 Bellerose Drive, St Albert, AB T8N 1P7 Canada. Mon-Fri 9AM-5PM MST