Super Privilege Problem While Restore

[enginaar]

Hello,

I'm trying to move to a new server but I'm having trouble while restoring backups. I've a few web sites using triggers and procedures in MySQL 5.x databases. While restoring them the da restore procedure returns an error like this:

"Unable to restore database teknoay_bogazici.sql to teknoay_bogazici : ERROR 1227 (42000) at line 534 in file: '/home/teknoay/backups/backup/teknoay_bogazici.sql': Access denied; you need the SUPER privilege for this operation"

How can I make this work?
Thanks.

 

[squirrelhost]

what is in line 534? anyways, don't forget mysqldump will include all triggers by default, but any stored procedures or functions are not included in the dump unless you explicitly request this. maybe that's the problem ? You also may need super privs in order to even create a trigger if it'd mysql 5.0

 

[enginaar]

There is a create view statement at line 534. I don't know which user that I have to add super privilege. da_admin and root has super privilege already.

It'a a directadmin site backup.

 

[scsi]

What kind of restore are you doing? Are you doing it under the admin user.

 

[enginaar]

yes. I'm doing it from admin backup/transfer section.

 

[searchmasters]

How do we give users the privileges to create views and triggers? How can we give super privileges to users - the option is not on the directadmin Modify User Privileges page.

Can the option be added to the directadmin Modify User Privileges page???

Or do we have to specifically ssh and add it?

How do we ssh to achieve that, and will that ssh operation be overwritten by directadmin at a later stage?