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