Community Q&A:
Access Denied Error 1227 When Importing SQL From Partial Backup
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.
====================================
Error
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
====================================
Error
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
ANSWERS
|
1
|
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 |
Want to share this Question?
Tweet
Help Center Login
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!
