Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /bin/bash
- apt-get install sshpass -y
- # or `yum install sshpass` for centos
- DATE=`date +%Y-%m-%d`
- DB_USER="user"
- DB_PASS="pass"
- DB_NAME="db_name"
- BACKUP_DIR="/var/www/db_backups/"
- REMOTE_SERVER="x.x.x.x"
- REMOTE_USER="root"
- REMOTE_PASS="pass"
- REMOTE_DIR="/var/www/backup_server/backup_dir/"
- mysqldump -u $DB_USER --password=$DB_PASS $DB_NAME > $BACKUP_DIR$DATE.sql
- sshpass -p $REMOTE_PASS rsync -avzhe ssh $BACKUP_DIR$DATE.sql $REMOTE_USER@$REMOTE_SERVER:$REMOTE_DIR
- #we considered you didn't put your public_key into server .ssh/authorized_keys file, otherwise just use:
- #rsync -avzhe ssh $BACKUP_DIR$DATE.sql $REMOTE_USER@$REMOTE_SERVER:$REMOTE_DIR
- rm $BACKUP_DIR$DATE.sql
Add Comment
Please, Sign In to add comment