Error importing MySQL RDS or Aurora DB with functions or views

johncnx(25)
Published in
#aws
Words
41
Reading
1 min
Listen
Play
9y

If you're receiving the following error message:

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

You need to remove DEFINER= This can be done manually or using the SED command below

sed 's/\sDEFINER=[^]+@[^]+//' -i dumpfile.sql

Error importing MySQL RDS or Aurora DB with functions or views | Ecency