Compress site and database for backup

backup.sh

#!/bin/bash
  
# Set Timestamp
time_stamp=$(date +%Y-%m-%d)

# Create Backup Directory
mkdir /backups/$time_stamp

# Backup Database
mysqldump -u root --password=DB_PASS --all-databases | gzip > /PATH/TO/SQL_DUMP.sql.gz

# Backup the web directory
echo 'Backing up files...';
tar -czf /backups/$time_stamp/$time_stamp-backup.tar.gz /home >/dev/null 2>&1

# Upload to Google Cloud Storage
echo 'Uploading to Cloud Storage...';
gsutil cp -r /backups/$time_stamp/ gs://BUCKET_PATH/ >/dev/null 2>&1

# Cleanup
echo 'Cleaning Up...';
rm -r /backups/$time_stamp