#!/bin/bash

#X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X#

#Turorial scp (Rsync) sem pedir senha

# ssh-keygen -t dsa -f ~/.ssh/id_dsa

# cat ~/.ssh/id_dsa.pub | ssh root@37.187.117.5 'cat - >> ~/.ssh/authorized_keys'

# cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

#X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X-X#

                          #X-X-X-X-X-X-Backup Arquivos-X-X-X-X-X-X#

log=/home/backup.log

DATA=`date +%d-%m-%Y-%H.%M`

zip -r /home/backups/bkp-"$DATA".zip /var/www/html

scp /home/backups/bkp-"$DATA".zip root@164.132.172.190:/home/teste

rm -f /home/backups/bkp-"$DATA".zip

echo ""
echo "Backup concluido!"
echo ""
echo "[`date +%d/%m/%y`] Backup realizado com sucesso - `date +%H:%M:%S`" >> $log
exit 0

                          #X-X-X-X-X-X-Backup MySQL-X-X-X-X-X-X#

#Usuario MySQL
user='root'
#Senha MySQL
pass='senhamysql'
conn="-u${user} -p${pass} -h localhost"

data="`date +%Y-%m-%d_%H-%M`"
#Diretorio onde sera salvo
bkdir="/home/backups/mysql"
bkfile="${bkdir}/mysql-${data}.tar.gz"

if [ ! -d ${bkdir} ]; then
 mkdir -p ${bkdir}
fi

sql="SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema');"

tmpdir='/tmp/backup-mysql'

if [ ! -d ${tmpdir} ]; then
 mkdir -p ${tmpdir}
fi

dbsfile="${tmpdir}/dbsfile"
mysql ${conn} -ANe"${sql}" > ${dbsfile}

for db in `cat ${dbsfile}`
do
echo "Criando backup da DB: ${db}"
arquivo="${tmpdir}/${db}-${data}.sql"
mysqldump ${conn} --routines --triggers --single-transaction ${db} > ${arquivo}
done
cd ${tmpdir}
tar -zcvf ${bkfile} *.sql
cd ~
rm -rf ${tmpdir}

METHOD="ssh"

# Ip maquina para onde o backup sera enviado.
SERVER="37.187.117.5"

#Diretorio pasta
B_DIRECTORY="/home/backups/mysql"

#Usuario
USER_NAME="root"

#Deixe em branco
SECRET=""

#Diretorio para onde os arquivos sera enviado
R_DIRECTORY="/home/bhs3"

#Porta SSH 22 ou FTP21
SSH_PORT=22

NCFTPPUT="/usr/bin/ncftpput"
TAR="/bin/tar"
SCP="/usr/bin/scp"

FILE="mysql.$(date +"%y-%m-%d").tar.gz"
OUTDIR="/tmp"
FILE_TO_GO="$OUTDIR/$FILE"

$TAR -zcf $FILE_TO_GO $B_DIRECTORY

if [ $METHOD = "ftp" ]
then
	$NCFTPPUT -m -z -u "$USER_NAME" -p "$SECRET" -P "$FTP_PORT" "$SERVER" "$R_DIRECTORY" "$FILE_TO_GO"
	EXIT_V="$?"
	case $EXIT_V in

	esac
else
	$SCP "$FILE_TO_GO" "$USER_NAME"@"$SERVER":/"$R_DIRECTORY"
	EXIT_V="$?"
	case $EXIT_V in
		0) O="Success";;
		1) O="Error";;
	esac
fi
rm -f $FILE_TO_GO

sleep 1

echo "Removendo pasta mysql em 5 segundos"

sleep 5

rm -f -r /home/backups/mysql

sleep 1

echo "backup efetuado com sucesso"