[FIX] Access denied; you need (at least one of) the SUPER privilege(s) for this operation [ AMAZON RDS ]
mysqldump generate trigger
cat yourDB | grep DEFINER= | less
so finish HIM!! remove DEFINER
DELIMITER ;;find him!!!!
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`%`*/ /*!50003 TRIGGER `after_insert_lead` AFTER INSERT ON `leads` FOR EACH ROW BEGIN
UPDATE analytics.mapping SET id_lead = NEW.id_lead WHERE mc_email = NEW.email;
END */;;
DELIMITER ;
cat yourDB | grep DEFINER= | less
so finish HIM!! remove DEFINER
just do itperl -pe 's/\sDEFINER=`[^`]+`@`[^`]+`//' < oldfile.sql > newfile.sql
or with source
mysql > source /path/your/file.sql
source
source2
Comments
Post a Comment