Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bas
- _tmp="/root"
- _dropbox="/root/Dropbox/Berlian/SQL"
- _sql_data="/root/.db_list.txt"
- _log="/var/log/box.com/backup"
- _now=$(date+"%Y_%m_%d_%k")
- # start dropbox
- /root/bin/dropbox.py start
- # loop backup database
- For a in `cat $_sql`
- do
- _user=`echo $a|awk -F "|" '{print $1}'`
- _pass=`echo $a|awk -F "|" '{print $2}'`
- _db=`echo $a |awk -F "|" '{print$3}'`
- mysqldump -u $_user--password=$_pass $_db>
- $_tmp/$_db-$_now.sql
- gzip -f -9 $_ db-$_now.sql
- mv $_tmp/$_db-$_now.sql.gz $_dropbox
- find $_dropbox -mtime +2 -delete
- done
- sleep 150
- /root/bin/dropbox.py stop
- cat/root/Dropbox/Tools/email.txt|msmtp -t ellymmathussa'diahbasuki@gmail.com
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement