Whenever I try to import a mysqldump export on another server, the triggers are never created, and if I remember correctly, I get an error messages that super user permission is required. IF I remove the definer it usually works but if there is a way I would prefer not having to edit the sql file.

When I just simply copy over the mdi, mdy and frm files everything works perfectly.

How could I import a mysqldump file so that triggers are created as well?

1 Answer 1


Make sure that the user importing the database has the SUPER priveledge.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .