stu1234556

// set URL HTTP
update magento2.core_config_data set value = 'https://magento2.local/'  where value = 'http://master-7rqtwti-veu4ppihqkiu2.eu.magentosite.cloud/';

//set URL HTTPS
update magento2.core_config_data set value = 'https://magento2.local/'  where value = 'https://master-7rqtwti-veu4ppihqkiu2.eu.magentosite.cloud/';

// purge review emails to prevent reviews sending by mistake
delete from magento2.pbh_sales_order_ekomi_review;


Run
php bin/magento setup:upgrade



[CONFIGURE INDEXERS]
// this recreates the triggers in the db

php bin/magento indexer:set-mode realtime
php bin/magento indexer:set-mode schedule


https://magento2.local/ should load default store

https://magento2.local/vsafetystoreview should load safety site


If there are errors loading sites, run the below commands to set file permissions:

Cd (to home folder)
Cd into magenta project folder

Replace screen with your Mac login

sudo dseditgroup -o edit -a sgreen -t user _www


find . -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \;
find ./var -type d -exec chmod 777 {} \;
find ./pub/media -type d -exec chmod 777 {} \;
find ./pub/static -type d -exec chmod 777 {} \;
chmod 777 ./app/etc
chmod 644 ./app/etc/*.xml
chown -R :_www .
chmod u+x bin/magento


[CRYPT]

// Get the crypt key from the prod server and update the load dev environment so we can decrypt data in database

// get from cloud CLI
/app/etc/env.php