Mysql backup using PGP and Google storage via gsutil

gistfile1.txt

#!/bin/sh

# Grab the date, captain!
DATE=`date`

# Dump all databases
mysqldump -u root --all-databases > /root/backup-sql/$DATE.sql

# Encrypt the backup based on a specified users PGP public key
gpg -e -r security@mydomain.com -a --trust-model always "/root/backup-sql/$DATE.sql"

# Upload to the specified bucket on GCP
gsutil cp "/root/backup-sql/$DATE.sql.asc" gs://mystoragename/

# Remove the non encrypted copy
rm /root/backup-sql/$DATE.sql

# Delete any backups over 7 days old, reference the bucket instead
find /root/backup-sql/ -ctime +7 | xargs -I{} rm {}