backupMysql2pCloud.sh

#!/bin/bash

set -e

username="backup"
password="NoFonE"

pcloud_username="pCloud username"
pcloud_password="pCloudoAuthToken"

mysql_backup_filename="/tmp/dump_final.tar.gz"
mysql_tmp_dir="/tmp/mysql_dump/"

rm -rf "$mysql_tmp_dir"
mkdir -p "$mysql_tmp_dir"

for I in $(mysql -u "$username" -p"$password" -e 'show databases' -s --skip-column-names | egrep -v "^(test|mysql|performance_schema|information_schema)$"); 
	do
		echo "$I.sql"
		mysqldump -u "$username" -p"$password" $I > "$mysql_tmp_dir$I.sql";
	done

tar -cvzf "$mysql_backup_filename" "$mysql_tmp_dir" && curl --progress-bar -F "username=$pcloud_username" -F "access_token=$pcloud_password" -F "folderid=0" -F "filename=$mysql_backup_filename" -F "file=@$mysql_backup_filename" https://api.pcloud.com/uploadfile && rm "$mysql_backup_filename" && rm -r "$mysql_tmp_dir"