matomoDump.sh

#!/bin/bash

set -euo pipefail

DECODED_SSH_KEY=decoded_key
touch $DECODED_SSH_KEY
chmod 600 $DECODED_SSH_KEY
echo $SSH_KEY | base64 -d > $DECODED_SSH_KEY

dbclient-fetcher mysql

MYSQL=$(echo $SCALINGO_MYSQL_URL | awk -F '[:/@?]' '{ print "mysqldump --extended-insert --no-autocommit --quick --single-transaction -h", $6, "-P", $7, "-u", $4, "-p" $5, $8 }') 
$MYSQL > matomo_backup_database.sql
echo 'Dump completed'

FILENAME=matomo-mysql-database-$(date +%Y-%m-%d-%H.%M.%S).sql.tar.gz
echo 'Archiving' $FILENAME
tar zcf $FILENAME matomo_backup_database.sql
echo $FILENAME 'archived'

echo 'Sending' $FILENAME
sftp -o StrictHostKeyChecking=no -i $DECODED_SSH_KEY -P2222 pix@pix-stats.cloud-ed.fr <<EOF
put $FILENAME /incoming
EOF

echo 'Transfer completed'