Subversion Repositories SmartDukaan

Rev

Rev 29002 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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

            11