[Unit] Description=Back up gliders database from main server [Service] User=mysql Type=simple ExecStartPre=/usr/bin/ssh -f -L3310:mars.noc.ac.uk:3306 gliders@mars.noc.ac.uk -N ExecStart=/usr/bin/bash -c "mysqldump -P 3310 -ugliders -p`cat ~/.gliders.password` gliders | gzip -9 > /local/mysql_backup/gliders.sql.gz" [Install] WantedBy=timers.target