Urgent! Issue with database restore ERROR 1227 (42000)

[Richard G]

Just transferring all accounts from one server to another.

On 2 accounts we get this error:

Unable to restore database richard&#95bl&#48t.sql to richard_bl0t : ERROR 1227 (42000) at line 1926 in file: '/home/richard/backups/backup/richard_bl0t.sql': Access denied; you need (at least one of) the SUPER privilege(s) for this operation

On the other account ofcourse with another database name.

I tried this solution:
http://help.directadmin.com/item.php?id=466

But that does not work. The mysql command just "sits" there.
When I have a look with mytop, it's there but it says "sleeping" and does nothing anymore.

So I had a look at the internet, we have this line in the sql file:

/*!50013 DEFINER=`richard_xxx`@`localhost` SQL SECURITY DEFINER */

I tried removing it and restoring the database, tried changing the name to da_admin and restoring, nothing works.
The process gets set asleep.

How can this be fixed.

 

[Richard G]

Strangely enough, today it worked that way as suggested in the help.
But I already fixed it by importing the databases manually by logging in as the user via phpmyadmin and importing the databases that way.

I'm almost 99% sure it was the Centrora Security plugin which caused this odd database protection behaviour.