Pimcore's object views are predefined with an owner, to migrate easily using mysqldump we need to replace that owner using the following command
mysqldump pimcore_database > pimcore_database_nonportable.sql
sed -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' \
pimcore_database_nonportable.sql > pimcore_database.sql