backup.sh

#!/usr/bin/env bash

# source environment variables
# https://www.clever-cloud.com/doc/admin-console/environment-variables/
source /home/bas/applicationrc

if [ -n ${INSTANCE_TYPE} ] && [ ${INSTANCE_TYPE} = 'production' ] && [ -n ${INSTANCE_NUMBER} ] && [ ${INSTANCE_NUMBER} -eq 0 ]
then

  DATE=`date +%Y%m%d-%H%M%S`
  
  #...
  
  mysqldump -u${MYSQL_SERENE_FORTRABBIT_USER} -h${MYSQL_SERENE_FORTRABBIT_HOST}  -p${MYSQL_SERENE_FORTRABBIT_PASSWORD} --all-databases > ${APP_HOME}/buckets/backups/$DATE.sql

  # zip file(s) with a specific password
  zip -P ${BACKUP_PASSWORD} ${APP_HOME}/buckets/backups/$DATE.zip ${APP_HOME}/buckets/backups/$DATE.sql

  rm ${APP_HOME}/buckets/backups/$DATE.sql

  echo "backups done"
fi