#!/bin/bash

#variaveis
user="root"
pass="jeanlocha"
backup_path="/home/jeanlocha/Área de Trabalho/dumps"
date=$(date +"%d-%b-%Y")

# pega os nome dos banco
DBS=$(mysql -u $user -p$pass  -e 'show databases;' | awk '{ print $1 }')

for db_name in $DBS; do
    if [ $db_name != "Database" ]
    then
       sudo mysqldump --user=$user --password=$pass  $db_name >"$backup_path"/$db_name-$date.sql
    fi
done

cd "$backup_path"

git add .

git commit -m "backup dumpbanco $date"

git push origin master