2 posts tagged with "how to"

Today I encountered a problem when trying to submit an app to the iTunes App Store.

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