34 lines
843 B
Bash
34 lines
843 B
Bash
#!/bin/bash
|
|
# this script is supposed to run as cronjob on the backup side
|
|
|
|
# Set bandwidthlimit; 1st parameter
|
|
if [ -n "$1" ];then
|
|
bw=$1
|
|
else
|
|
bw=100000
|
|
fi
|
|
|
|
# copy DB
|
|
/usr/bin/rsync --bwlimit=$bw -ae 'ssh -p 64222 -i /home/nc-cloner/.ssh/id_rsa -o PreferredAuthentications=publickey' user@example.com:/home/nc-cloner/nc-bak /home/username/
|
|
|
|
# Copy Files
|
|
/usr/bin/rsync --bwlimit=$bw -ae 'ssh -p 64222 -i /home/nc-cloner/.ssh/id_rsa -o PreferredAuthentications=publickey' username@example.com:/home/username/ncp_data /home/username/
|
|
|
|
# Vars
|
|
host=localhost
|
|
user=xxxxxxxxxxxxxxxxx
|
|
pass="xxxxxxxxxxxxxxxx"
|
|
db=nextcloud
|
|
|
|
cd /home/username/nc-bak
|
|
|
|
DBFILE=nc-db.sql.gz
|
|
if test -f "$DBFILE"; then
|
|
/bin/gunzip nc-db.sql.gz
|
|
|
|
# overwrite NC DB with copy from production
|
|
/usr/bin/mysql -h$host -u$user -p$pass $db < nc-db.sql
|
|
|
|
rm nc-db.sql*
|
|
fi
|