Access Denied Error 1227 When Importing SQL From Partial Backup

Asked by:
drumma777 / 8 Points
2013-05-17 6:32 pm EST
I have a backup of a MySQL database that I attempted to restore using the Restore feature in cPanel, but only 11 out of the 177 tables were imported. So I tried using phpMyAdmin to import the data that way and I receive the following error message.

SQL query:

DELIMITER ;; /*!50003 CREATE*//*!50017 DEFINER=`userna5_dataname`@`localhost`*//*!50003 TRIGGER dataname_address_after_insert after insert ON dataname_address FOR EACH ROW BEGIN UPDATE dataname_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.contact_id; END */ ;;

MySQL said:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I did not see this error message in the Support Center anywhere so that is why I need an answer from someone who can help me.....asap if possible.

Thank-you very much!

Rick Monyer

To ask this user for more information, please first login.

To submit an answer, please login.



2,132 Points
2013-05-17 6:57 pm EST
Thank you for your question Rick !

Database users on our servers only have database access. You cannot "CREATE" databases through SQL imports. Databases can only be created through the "MySQL Databases" in the cPanel. In your SQL code you have a "CREATE" statement on line 1227.

To get your database to import, you will need to edit the SQL file and remove the "CREATE" statements from your SQL file, or create another database dump that does not contain any "CREATE" statements. Sorry for the inconvenience.

Best regards,
James R

To submit a comment on this answer, please first login.

I commented out all the CREATE statements and it all imported fine. I kept seeing that suggestion, but I thought it only applied for a CREATE DATABASE statement. Thank-you jamesr!
8 Points

2013-05-17 9:57 pm EST
Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.