wpbackup

#!/bin/bash
DBUSER=''
DBPASS=''
DBHOST=''
DBNAME=''
SSHUSER=''
SSHHOST=''
SSHKEYPATH=''
RSYNCSRCPATH=''
RSYNCDESTPATH=''
CHOWNUSER=''
CHOWNGROUP=''

ssh -t $SSHUSER@$SSHHOST  'mysqldump ${DBNAME} --add-drop-table --no-tablespaces -h  -u ${DBUSER} -p${DBPASS} > sqlbackupforroot.sql$
rsync -avh  -e "ssh -i ${SSHKEYPATH}" SSHUSER@SSHHOST:~/sqlbackupforroot.sql  /root/
ssh -t $SSHUSER@$SSHHOST  'rm sqlbackupforroot.sql;exit;'
sed 's/www\.domain\.tld/www.NEWDOMAIN.tld/g' /root/sqlbackupforroot.sql > /root/sqlbackupforrootfixed.sql
mysql -h localhost -u $DBUSER -p$DBPASS  $DBNAME < /root/sqlbackupforrootfixed.sql
rm /root/sqlbackupforrootfixed.sql
rm /root/sqlbackupforroot.sql
echo 'fertig';
rsync -avh --exclude-from='exclude.lst' -og --chown=$CHOWNUSER:$CHOWNGROUP --chmod=D0755,F0644 -e "ssh -i ${SSHKEYPATH}" $SSHUSER@$SSHHOST:$RSYNCSRCPATH $RSYNCDESTPATH