[odoo manual backups] create manual backup and transfer via ssh #odoo

odoo_backup.sh

# Create a manual odoo backup
sudo su - dev1 -c "/opt/online/online_tools/start.py --instance-dir /opt/online/dev1 --backup /opt/online/dev1/update/care_manual_backup --stop-after-init"
sudo su - dev2 -c "/opt/online/online_tools/start.py --instance-dir /opt/online/dev2 --backup /opt/online/dev2/update/care_manual_backup --stop-after-init"
sudo su - npha -c "/opt/online/online_tools/start.py --instance-dir /opt/online/npha --backup /opt/online/npha/update/manual_backup --stop-after-init"

# Via salt Master
salt "online4" cmd.run 'sudo su - dev1 -c "/opt/online/online_tools/start.py --instance-dir /opt/online/dev1 --backup /opt/online/dev1/update/dev1_sebi_backup --stop-after-init"'

salt "online4" cmd.run 'ls -al /opt/online/dev1/update'
salt "online4" cmd.run 'll /opt/online/dev1/update'


# Zip Backup folder
cd /opt/online/npha/update
tar -zcvf mybackup.tar.gz /opt/online/npha/update/npha-manual_backup-2018-11-20_14-36-51

# Change rights and folder location to make it accessible from macbook pro later on
chmod o=r mybackup.tar.gz
mv mybackup.tar.gz /opt/online/

# Copy file from host to local machine
# ATTENTION: !!! RUN THIS SCP COMANND ON MACBOOK PRO !!!
# HINT: scp <source> <destination>
scp online4@192.168.37.126:/opt/online/mybackup.tar.gz /Users/mkarrer/Desktop/

# Remove backup file from /opt/online
rm /opt/online/mybackup.tar.gz


# RESTORE OF AN BACKUP
# --------------------
# Backup von care ist vom 2019.01.18 00:15

service dev1 stop
sudo su - dev1 -c "/opt/online/online_tools/start.py --instance-dir /opt/online/dev1 --restore /opt/online/dev1/update/care_cleaned_backup --stop-after-init"

service dev2 stop
sudo su - dev2 -c "/opt/online/online_tools/start.py --instance-dir /opt/online/dev2 --restore /opt/online/dev2/update/care_cleaned_backup --stop-after-init"
# ACHTUNG: Im care_cleaned_backup ist das pw von dev1! muss nach dem restore noch umgestellt werden :)


# Copy Backup from Mac to online4
$online4: scp mkarrer@192.168.38.10:/Users/mkarrer/Entwicklung/github/online/care/update/care-manual_backup-2019-01-29_14-01-17.zip /opt/online/dev1/update

scp /Users/mkarrer/Entwicklung/github/online/care/update/care-manual_backup-2019-01-29_14-29-31.zip online4@192.168.37.126:/home/online4/care