Subversion Repositories SmartDukaan

Rev

Rev 29002 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

#!/bin/bash
BACKUP_DIR=/root/.backup/daily
#SERVER=root@192.168.190.112
SERVER=root@74.207.248.52
BACKUP_FILE=$(sshpass -p shop2020 ssh $SERVER 'ls -t /root/.backup/daily | head -1')
echo "==========SSH Remote File $BACKUP_FILE ============"
sshpass -p shop2020 scp $SERVER:$BACKUP_DIR/$BACKUP_FILE .
echo "==========SSH Remote File $BACKUP_FILE completed==="
zcat ./$BACKUP_FILE  > dump.sql
mysql -uroot -pshop2020 < dump.sql