Advertisement
Sandelim

Backup WordPress ke Dropbox

Feb 28th, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.67 KB | None | 0 0
  1. #!/bin/bas
  2. _tmp="/root"
  3. _dropbox="/root/Dropbox/Berlian/SQL"
  4. _sql_data="/root/.db_list.txt"
  5. _log="/var/log/box.com/backup"
  6. _now=$(date+"%Y_%m_%d_%k")
  7. # start dropbox
  8. /root/bin/dropbox.py start
  9. # loop backup database
  10. For a in `cat $_sql`
  11. do
  12.    _user=`echo $a|awk -F "|" '{print $1}'`
  13.    _pass=`echo $a|awk -F "|" '{print $2}'`
  14.    _db=`echo $a |awk -F "|" '{print$3}'`
  15.    mysqldump -u $_user--password=$_pass $_db>
  16.     $_tmp/$_db-$_now.sql
  17.    gzip -f -9 $_ db-$_now.sql
  18.    mv $_tmp/$_db-$_now.sql.gz $_dropbox
  19.    find $_dropbox -mtime +2 -delete
  20. done
  21. sleep 150
  22. /root/bin/dropbox.py stop
  23. cat/root/Dropbox/Tools/email.txt|msmtp -t ellymmathussa'diahbasuki@gmail.com
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement