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.
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 */ ;;
#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.
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.
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!