Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- # DATA vai imprimir a data no estio ano-mes-dia
- DATA=$(date +"%Y-%m-%d-%T")
- # o diretorio onde o arquivo serĂ¡ salvo no meu caso
- DATABASE="phpipam"
- NOME="/tmp/mysql/$DATABASE-$DATA.sql"
- DATABASE2="portal"
- NOME2="/tmp/mysql/$DATABASE2-$DATA.sql"
- DATABASE3="zabbix"
- NOME3="/tmp/mysql/$DATABASE3-$DATA.sql"
- ### MySQL Server Login Info ###
- HOST="localhost"
- USER="root"
- PASSWORD="#&P4ss$w0rd%!#"
- mysqldump -u $USER -h $HOST -p$PASSWORD $DATABASE | gzip -9 > $NOME.gz
- mysqldump -u $USER -h $HOST -p$PASSWORD $DATABASE2 | gzip -9 > $NOME2.gz
- mysqldump -u $USER -h $HOST -p$PASSWORD $DATABASE3 | gzip -9 > $NOME3.gz
- ### FTP SERVER Login info ###
- FTPU="AdminFTP"
- FTPP="#P4ss@F59@&"
- FTPS="289.13.517.221"
- 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