Advertisement
Guest User

Untitled

a guest
Jan 31st, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.84 KB | None | 0 0
  1. #!/bin/sh
  2.  
  3. # DATA vai imprimir a data no estio ano-mes-dia
  4. DATA=$(date +"%Y-%m-%d-%T")
  5. # o diretorio onde o arquivo serĂ¡ salvo no meu caso
  6.  
  7. DATABASE="phpipam"
  8. NOME="/tmp/mysql/$DATABASE-$DATA.sql"
  9.  
  10. DATABASE2="portal"
  11. NOME2="/tmp/mysql/$DATABASE2-$DATA.sql"
  12.  
  13.  
  14. DATABASE3="zabbix"
  15. NOME3="/tmp/mysql/$DATABASE3-$DATA.sql"
  16.  
  17.  
  18. ### MySQL Server Login Info ###
  19. HOST="localhost"
  20. USER="root"
  21. PASSWORD="#&P4ss$w0rd%!#"
  22.  
  23.  
  24. mysqldump -u $USER -h $HOST -p$PASSWORD $DATABASE | gzip -9 > $NOME.gz
  25. mysqldump -u $USER -h $HOST -p$PASSWORD $DATABASE2 | gzip -9 > $NOME2.gz
  26. mysqldump -u $USER -h $HOST -p$PASSWORD $DATABASE3 | gzip -9 > $NOME3.gz
  27.  
  28. ### FTP SERVER Login info ###
  29. FTPU="AdminFTP"
  30. FTPP="#P4ss@F59@&"
  31. FTPS="289.13.517.221"
  32.  
  33.  
  34.  
  35. lftp -u ftp,'#T3mp3st4d3@' -e "mkdir /mysql/$DATA;cd /mysql/$DATA; mput /tmp/mysql/*; quit" $FTPS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement