How To: Backup to Google Cloud Storage

[Jason_Hilton]

Hey Guys,
Hope this is helpful to someone. My Plesk server runs on Google Compute Engine, and backups to a Google Cloud Storage Bucket via this script:

#!/bin/bash
export BOTO_CONFIG="/path/to/.boto"

# Create the backups appending YYMMDD to the end of the file name.
mysqldump databasename -u username -ppassword > database_$(date +%y%m%d).sql
tar -czf httpdocs_$(date +%y%m%d).tar.gz /var/www/vhosts/example.com/httpdocs/

# Compress the database backup.
gzip database_$(date +%y%m%d).sql

# Upload the backups to your bucket, and pipe output to null to prevent cron from emailing you several pages of output.
gsutil cp -L databasereport.csv database_$(date +%y%m%d).sql.gz gs://bucketname 2>/dev/null
gsutil cp -L httpdocsreport.csv httpdocs_$(date +%y%m%d).tar.gz gs://bucketname 2>/dev/null

# Remove the backups from the server.
rm httpdocs_$(date +%y%m%d).tar.gz
rm database_$(date +%y%m%d).sql.gz

# Output the upload reports for Cron to email (if you want).
cut --delimiter=, -f1,9 databasereport.csv
cut --delimiter=, -f1,9 httpdocsreport.csv

# Remove the upload reports.
rm databasereport.csv
rm httpdocsreport.csv

 

[sysmanaging]

Dear Jason,
I'm trying to use your script but what I have to insert in ".boto" file ?

Thank you

 

[AYamshanov]

Hi sysmanaging,

Try to look at page "config - Obtain credentials and create configuration file  |  Cloud Storage Documentation  |  Google Cloud" procedure, it looks like BOTO_CONFIG is required for `gsutil`.

If you want to save backups to Google Drive, you can use the Google Drive Backup extension (Google Drive Backup - Plesk Extensions) with Plesk 17.8