Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
29000 amit.gupta 1 
#!/bin/bash
2 
BACKUP_DIR=/root/.backup/daily
29094 amit.gupta 3 
#SERVER=root@192.168.190.112
4 
SERVER=root@74.207.248.52
29000 amit.gupta 5 
BACKUP_FILE=$(sshpass -p shop2020 ssh $SERVER 'ls -t /root/.backup/daily | head -1')
29094 amit.gupta 6 
echo "==========SSH Remote File $BACKUP_FILE ============"
29000 amit.gupta 7 
sshpass -p shop2020 scp $SERVER:$BACKUP_DIR/$BACKUP_FILE .
29094 amit.gupta 8 
echo "==========SSH Remote File $BACKUP_FILE completed==="
9 
zcat ./$BACKUP_FILE  > dump.sql
29002 amit.gupta 10 
mysql -uroot -pshop2020 < dump.sql