Skip to main content

· One min read

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

· One min read

Back when we first moved Gather Digital to MediaCityUK, we had some time to kill, so we analysed all of the businesses in the local area, and showed a few statistics on what companies were doing via their socials