Several people have suggested a more flexible approach at
mysqldump output in matter of user privileges.
When you dump the data structure for views, triggers, and
stored routines, you also dump the permissions related to
such objects, with the DEFINER clause.
It would be nice to have such DEFINER clauses removed, or
even replaced with the appropriate users in the new
The mysqldump filter was created with this need in
mind. It allows you to remove all DEFINER clauses and eventually
replacing them with a better one.
mysqldump --no-data sakila | dump_filter --delete > …