4 steps toward hosting your own Email Marketing Platform.
· 5 min read
This post was originally published by me here
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