1

I downloaded a database backup from the craft back-end. I've tried to restore it via PHPMyAdmin and MySQL workbench, and I get the following errors:

ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation

At line 18 in the SQL file:

SET @@SESSION.SQL_LOG_BIN= 0;

Is there any way I can get around this so I can restore this database? I'm desperate right now.

1

Here is the Solution. Clearing a couple of lines from the SQL file made it work.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.