mysql errors after restoring backup

[zl0y]

Hello, I have try to restore my users from DA admin backup and have errors with mysql

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

and user doesn't restored successfully.

How I can solve this problem?

mysql 5.1.59
os: debian 6 x64

 

[zl0y]

It seems that mysql doesn't not allow to create views and triggers unpriveleged users. How I can override this with superadmin privileges. I have > 200 users backups restoring with errors

 

[mr.applesauce]

Your root user should have all the privileges it needs.

 

[zl0y]

Correct, but when I have to restore from backup used customer user not a root.

 

[mr.applesauce]

You can use phpmyadmin after creating the database. Then remove CREATE DATABASE from the sql file.

 

[zEitEr]

And what is there at line 1174 in file: '/home/someuser/backups/backup/someuser_somedb.sql'?

 

[zl0y]

create trigger. It's is possible to use da_admin account instead of user when restore from admin backup?

 

[zEitEr]

create trigger. It's is possible to use da_admin account instead of user when restore from admin backup?

I guess, no. You should restore that manually.