backups.sh

# Downloads Backups
https://www.rollseda.com/backup/
https://www.foa.com.py/backup/
https://www.fodacgeral.com/backup/
https://www.rpa.com.py/backup/
https://www.totalbloker.com/backup/
https://www.tudaobrasil.com/backup/
https://www.ecococoproducts.com/backup/
https://www.secretsofnay.com/backup/
https://www.desvall.com/backup/
https://www.zomovape.com/backup/
https://www.zomopaper.com/backup/

mkdir ~/backups-foa; cd ~/backups-foa;

#zomozpod
mv ~/Downloads/zomozpod-database.sql.gz .;gzip -d zomozpod-database.sql.gz;
mv ~/Downloads/zomozpod-uploads.tar.gz .;tar xvf zomozpod-uploads.tar.gz;
mysql -h localhost -u marcos -p123123 zomozpod < ~/backups-foa/zomozpod-database.sql

#rollseda
mv ~/Downloads/rollseda-database.sql.gz .;gzip -d rollseda-database.sql.gz;
mv ~/Downloads/rollseda-uploads.tar.gz .; mkdir rollseda; tar xvf rollseda-uploads.tar.gz --directory rollseda; rsync -rah ~/backups-foa/rollseda/home/rollseda/www/web/app/uploads/ /var/www/html/site-rollseda.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-rollseda.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 rollseda < ~/backups-foa/rollseda-database.sql

#foa
mv ~/Downloads/foa-database.sql.gz .;gzip -d foa-database.sql.gz;
mv ~/Downloads/foa-uploads.tar.gz .; mkdir foa; tar xvf foa-uploads.tar.gz --directory foa; rsync -rah ~/backups-foa/foa/home/foa/www/web/app/uploads/ /var/www/html/site-foa.com.py/web/app/uploads;chmod 777 -Rv /var/www/html/site-foa.com.py/web/app/uploads;
mysql -h localhost -u marcos -p123123 foa < ~/backups-foa/foa-database.sql

#fodacgeral
mv ~/Downloads/fodacgeral-database.sql.gz .; gzip -d 	fodacgeral-database.sql.gz;
mv ~/Downloads/fodacgeral-uploads.tar.gz .; mkdir fodacgeral; tar xvf fodacgeral-uploads.tar.gz --directory fodacgeral; rsync -rah ~/backups-foa/fodacgeral/home/fodacgeral/www/web/app/uploads/ /var/www/html/site-fodacgeral.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-fodacgeral.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 fodacgeral < ~/backups-foa/fodacgeral-database.sql

#rpa
mv ~/Downloads/rpa-database.sql.gz .;gzip -d 	rpa-database.sql.gz;
mv ~/Downloads/rpa-uploads.tar.gz .; mkdir rpa; tar xvf rpa-uploads.tar.gz --directory rpa; rsync -rah ~/backups-foa/rpa/home/rpa/www/web/app/uploads/ /var/www/html/site-rpa.com.py/web/app/uploads;chmod 777 -Rv /var/www/html/site-rpa.com.py/web/app/uploads;
mysql -h localhost -u marcos -p123123 rpa < ~/backups-foa/rpa-database.sql

#totalbloker
mv ~/Downloads/totalbloker-database.sql.gz .;gzip -d 	totalbloker-database.sql.gz;
mv ~/Downloads/totalbloker-uploads.tar.gz .; mkdir totalbloker; tar xvf totalbloker-uploads.tar.gz --directory totalbloker; rsync -rah ~/backups-foa/totalbloker/home/totalbloker/www/web/app/uploads/ /var/www/html/site-totalbloker.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-totalbloker.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 totalbloker < ~/backups-foa/totalbloker-database.sql

#tudaobrasil
mv ~/Downloads/tudaobrasil-database.sql.gz .;gzip -d 	tudaobrasil-database.sql.gz;
mv ~/Downloads/tudaobrasil-uploads.tar.gz .; tar xvf tudaobrasil-uploads.tar.gz --directory tudaobrasil; rsync -rah ~/backups-foa/tudaobrasil/home/tudaobrasil/www/web/app/uploads/ /var/www/html/site-tudaobrasil.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-tudaobrasil.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 tudaobrasil < ~/backups-foa/tudaobrasil-database.sql

#ecococoproducts
mv ~/Downloads/ecococoproducts-database.sql.gz .;gzip -d 	ecococoproducts-database.sql.gz;
mv ~/Downloads/ecococoproducts-uploads.tar.gz .; tar xvf ecococoproducts-uploads.tar.gz --directory ecococoproducts; rsync -rah ~/backups-foa/ecococoproducts/home/ecococoproducts/www/web/app/uploads/ /var/www/html/site-ecococoproducts.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-ecococoproducts.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 ecococoproducts < ~/backups-foa/ecococoproducts-database.sql

#secretsofnay
mv ~/Downloads/secretsofnay-database.sql.gz .;gzip -d 	secretsofnay-database.sql.gz;
mv ~/Downloads/secretsofnay-uploads.tar.gz .; tar xvf secretsofnay-uploads.tar.gz --directory secretsofnay; rsync -rah ~/backups-foa/secretsofnay/home/secretsofnay/www/web/app/uploads/ /var/www/html/site-secretsofnay.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-secretsofnay.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 secretsofnay < ~/backups-foa/secretsofnay-database.sql

#desvall
mv ~/Downloads/desvall-database.sql.gz .;gzip -d 	desvall-database.sql.gz;
mv ~/Downloads/desvall-uploads.tar.gz .; tar xvf desvall-uploads.tar.gz --directory desvall; rsync -rah ~/backups-foa/desvall/home/desvall/www/web/app/uploads/ /var/www/html/site-desvall.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-desvall.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 desvall < ~/backups-foa/desvall-database.sql

#zomovape
mv ~/Downloads/zomovape-database.sql.gz .;gzip -d 	zomovape-database.sql.gz;
mv ~/Downloads/zomovape-uploads.tar.gz .; tar xvf zomovape-uploads.tar.gz --directory zomovape; rsync -rah ~/backups-foa/zomovape/home/zomovape/www/web/app/uploads/ /var/www/html/site-zomovape.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-zomovape.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 zomovape < ~/backups-foa/zomovape-database.sql

#zomopaper
mv ~/Downloads/zomopaper-database.sql.gz .;gzip -d zomopaper-database.sql.gz;
mv ~/Downloads/zomopaper-uploads.tar.gz .; tar xvf zomopaper-uploads.tar.gz --directory zomopaper; rsync -rah ~/backups-foa/zomopaper/home/zomopaper/www/web/app/uploads/ /var/www/html/site-zomopaper.com/web/app/uploads;chmod 777 -Rv /var/www/html/site-zomopaper.com/web/app/uploads;
mysql -h localhost -u marcos -p123123 zomopaper < ~/backups-foa/zomopaper-database.sql

databases.sql

#Criar banco de dados
create database zomozpod;
create database rollseda;
create database zomopaper;
create database zomovape;
create database fodacgeral;
create database totalbloker;
create database foa;
create database rpa;
create database desvdall;
create database secretsofnay;
create database tudaobrasil;
create database ecococoproducts;
create database tradederesultado;

deploys.sh

#Ativar os módulos dos virtualHosts
sudo a2ensite foa.conf rpa.local.conf zomovape.conf secretsofnay.conf zomozpod.conf fodac.conf desvall.conf rollseda.conf totalbloker.conf ecococoproducts.conf rpa.conf zomopaper.conf

#Processos de deploy

#Zomozpod
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-zomozpod.com.git
cd /var/www/html/site-zomozpod.com/; composer install;
cd web/app/themes/zomozpod/; composer install;
yarn add node-sass; yarn;
create database zomozpod;

#Rollseda
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-rollseda.com.git
cd /var/www/html/site-rollseda.com/; composer install;
cd web/app/themes/rollseda/; composer install;
yarn add node-sass; yarn;
create database rollseda;

#Zomopaper
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-zomopaper.com.git
cd /var/www/html/site-zomopaper.com/;  composer install;
cd web/app/themes/zomopaper/; composer install;
yarn add node-sass; yarn;
create database zomopaper;

#Zomovape
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-zomovape.com.git
cd /var/www/html/site-zomovape.com/;  composer install;
cd web/app/themes/zomovape/; composer install;
yarn add node-sass; yarn;
create database zomovape;

#Fodacgeral
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-fodacgeral.com.git
cd /var/www/html/site-fodacgeral.com/;  composer install;
cd web/app/themes/fodac/; composer install;
yarn add node-sass; yarn;
create database fodacgeral;
#Baixar pasta uploads | baixar sql e configurar o banco de dados


#Totalbloker
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-totalbloker.com.git
cd /var/www/html/site-totalbloker.com/;  composer install;
cd web/app/themes/totalbloker/; composer install;
yarn add node-sass; yarn;
create database totalbloker;

#Foa
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-foa.com.py.git
cd /var/www/html/site-foa.com.py/;  composer install;
cd web/app/themes/foa/; composer install;
yarn add node-sass; yarn;
create database foa;

#Rpa
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-rpa.com.py.git
cd /var/www/html/site-rpa.com.py/;  composer install;
cd web/app/themes/rpa/; composer install;
yarn add node-sass; yarn;
create database rpa;

#Desvall
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-desvall.com.git
cd /var/www/html/site-desvall.com/;  composer install;
cd web/app/themes/desvall/; composer install;
yarn add node-sass; yarn;
create database desvdall;

#Secretsofnay
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-secretsofnay.com.git
cd /var/www/html/site-secretsofnay.com/; composer install;
cd web/app/themes/secretsofnay/; composer install;
yarn add node-sass; yarn;
create database secretsofnay;

#Tudaobrasil
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-tudaobrasil.com.git
cd /var/www/html/site-tudaobrasil.com/;  composer install;
cd web/app/themes/tudaobrasil/; composer install;
yarn add node-sass; yarn;
create database tudaobrasil;

#Ecococoproducts
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-ecococoproducts.com.git
cd /var/www/html/site-ecococoproducts.com/;  composer install;
cd web/app/themes/ecococoproducts/; composer install;
yarn add node-sass; yarn;
create database ecococoproducts;

#Tradederesultado
cd /var/www/html
git clone https://marcos-foa@bitbucket.org/devops-foa/site-tradederesultado.com.git
cd /var/www/html/site-tradederesultado.com/;  composer install;
cd web/app/themes/tradederesultado/; composer install;
yarn add node-sass; yarn;
create database tradederesultado;

phpstorm.sh

#Copiar todas as pastas .idea referentes aos arquivos de configurações do phpstorm
rsync -rahv --list-only --include '.idea' --include '/var/www/html/*' --exclude '*' /var/www/html/ .
#colar todas as pastas do .idea referentes aos arquivos de configurações do phpstorm
rsync -rahv ~/Downloads/bkps-ideas/html/ /var/www/html/

replaces-wp-cli.sh

#Aplicar os Replaces com wp-cli

#zomozpod
wp --allow-root search-replace 'https://www.zomozpod.com' 'http://zomozpod.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'zomozpod.com' 'zomozpod.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#rollseda
wp --allow-root search-replace 'rollseda.com' 'rollseda.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'https://www.rollseda.com' 'http://rollseda.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#foa
wp --allow-root search-replace 'https://www.foa.com.py' 'http://foa.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#fodacgeral
wp --allow-root search-replace 'https://www.fodacgeral.com' 'http://fodac.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'fodacgeral.com' 'fodac.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#rpa
wp --allow-root search-replace 'https://www.rpa.com.py' 'http://rpa.local' --recurse-objects
wp --allow-root search-replace 'rpa.com.py' 'rpa.local' --recurse-objects

#totalbloker
wp --allow-root search-replace 'https://www.totalbloker.com' 'http://totalbloker.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'totalbloker.com' 'totalbloker.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#tudaobrasil
wp --allow-root search-replace 'https://www.tudaobrasil.com' 'http://tudaobrasil.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'tudaobrasil.com' 'tudaobrasil.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#ecococoproducts
wp --allow-root search-replace 'https://www.ecococoproducts.com' 'http://ecococoproducts.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'ecococoproducts.com' 'ecococoproducts.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#secretsofnay
wp --allow-root search-replace 'https://www.secretsofnay.com' 'http://secretsofnay.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'secretsofnay.com' 'secretsofnay.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#desvall
wp --allow-root search-replace 'https://www.desvall.com' 'http://desvall.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'desvall.com' 'desvall.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#zomovape
wp --allow-root search-replace 'https://www.zomovape.com' 'http://zomovape.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'zomovape.com' 'zomovape.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users

#zomopaper
wp --allow-root search-replace 'https://www.zomopaper.com' 'http://zomopaper.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users
wp --allow-root search-replace 'zomopaper.com' 'zomopaper.local' --recurse-objects --skip-columns=guid --skip-tables=wp_users