Backup Script to Google Drive using rclone (RunCloud)

I recently joined RunCloud the other day and didn’t like their backup function, so I decided to create my own Backup Script that puts the files directly on Google Drive!

 

Update 2020: The old method no longer works. The new backup script example using rclone is below. It’s very quick!

 

How to backup your files to Google Drive using rclone

I followed this tutorial to set up rclone, and when I got to the question “use auto config?” – select No and it will provide you a Google authentication link which you can copy/paste into your browser to complete the set-up.

 

#!/bin/bash

DATE=`date +%m-%d-%Y`
for dir in /home/*/webapps/*
do
  base=$(basename "$dir")
  tar -cf "/tmp/${base}-${DATE}.tar" -C "$dir" .
  rclone sync /tmp/${base}-${DATE}.tar "Google Drive:My Folder/My Sub Folder"
  rm -rf /tmp/${base}-${DATE}.tar
done


USER="root"
PASSWORD="<MYSQL_ROOT_PASSWORD>"
databases=`mysql -u $USER -p$PASSWORD --batch --skip-column-names -e "SHOW DATABASES;" | grep -E -v "(information|performance)_schema"`

for db in $databases
do
	echo "Dumping database: $db"
	mysqldump -u $USER -p$PASSWORD --databases $db > /tmp/$db-`date +%m-%d-%Y`.sql
	tar -cf /tmp/$db-`date +%m-%d-%Y`.sql.tar -C /tmp/ $db-`date +%m-%d-%Y`.sql
	rclone sync /tmp/$db-`date +%m-%d-%Y`.sql.tar "Google Drive:My Folder/My Sub Folder"
	rm -rf /tmp/$db-`date +%m-%d-%Y`.sql
	rm -rf /tmp/$db-`date +%m-%d-%Y`.sql.tar
done

 

** This is the end of the tutorial. The older content which no longer works is below.

 

Install Google Drive to your Linux Server

First, you’ll need to install Google Drive to your Linux machine. This simply installs Drive – not the sync functions, etc.

wget -O drive https://drive.google.com/uc?id=0B3X9GlR6EmbnMHBMVWtKaEZXdDg 
mv drive /usr/sbin/drive 
chmod 755 /usr/sbin/drive

Next, you’ll need to start drive and then follow the instructions. Once you’ve done that and linked Google Drive to your linux server, we’re ready!

drive

Install the Backup Script

Ok, so the script below basically backups all the web applications and databases into their own .tar.gz file. I run this below script once a day during the morning hours.

#!/bin/bash

DATE=`date +%m-%d-%Y`
for dir in /home/*/webapps/*
do
  base=$(basename "$dir")
  tar -czf "/tmp/${base}-${DATE}.tar.gz" -C "$dir" .
  drive upload -p '<GOOGLE_DRIVE_FOLDER_ID>' -f /tmp/${base}-${DATE}.tar.gz
  rm -rf /tmp/${base}-${DATE}.tar.gz
done


USER="root"
PASSWORD="<MYSQL_ROOT_PASSWORD>"
databases=`mysql -u $USER -p$PASSWORD --batch --skip-column-names -e "SHOW DATABASES;" | grep -E -v "(information|performance)_schema"`

for db in $databases
do
  mysqldump -u $USER -p$PASSWORD --databases $db > /tmp/$db-`date +%m-%d-%Y`.sql
  tar -czf /tmp/$db-`date +%m-%d-%Y`.sql.tar.gz -C /tmp/ $db-`date +%m-%d-%Y`.sql
  drive upload -p '<GOOGLE_DRIVE_FOLDER_ID>' -f /tmp/$db-`date +%m-%d-%Y`.sql.tar.gz
  rm -rf /tmp/$db-`date +%m-%d-%Y`.sql
  rm -rf /tmp/$db-`date +%m-%d-%Y`.sql.tar.gz
done

How to make the backup script work

1. Replace <GOOGLE_DRIVE_FOLDER_ID> with the Google Drive folder ID. This usually looks like random characters. To get it, just double click the backup folder and look in the address bar.
2. Once you have set-up a server with RunCloud it provides you with the MySQL root password. Replace <MYSQL_ROOT_PASSWORD> with that password.

That’s it! You can now run the script to make sure it sends the files directly to your selected Google Drive folder.

 

Delete the files after X days

If you’re looking to delete files from google drive after X amount of days, then look no further because I created that script too.