#!/bin/bash

: << 'Comentario'
Comentario

########BIOCULTIVOS##########

# Credenciales
user="gbcoha2h_biodbopf"
password="j(&5wdL)1&nj"
host="localhost"
db_name="gbcoha2h_biocultivos"

backup_path="/home/gbcoha2h/Backups/Biocultivos"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;




########BIZTRACK##########

# Credenciales
user="gbcoha2h_biztrackdb"
password="(ecYEO!PD4iW$"
host="localhost"
db_name="gbcoha2h_biztrack"

backup_path="/home/gbcoha2h/Backups/Biztrack"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;




########CYEMEDICA##########

# Credenciales
user="gbcoha2h_cyemebd"
password="a@(UbKrKv#nf"
host="localhost"
db_name="gbcoha2h_cyemedica"

backup_path="/home/gbcoha2h/Backups/Cyemedica"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;




########GLOBAL OPF##########

# Credenciales
user="gbcoha2h_wp_glo"
password=")gS9Pm6!p7"
host="localhost"
db_name="gbcoha2h_wp_glo"

backup_path="/home/gbcoha2h/Backups/GlobalOpf"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;




########HOSER##########

# Credenciales
user="gbcoha2h_hoserdb"
password='ho&K!}JKhG$S.68c0'
host="localhost"
db_name="gbcoha2h_hoser"

backup_path="/home/gbcoha2h/Backups/Hoser"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql



#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;



########NUCLEO##########
: << 'Comentario'
# Credenciales
user="gbcoha2h_nucleodb"
password="nucdbtpVmRy$)yWUA"
host="localhost"
db_name="gbcoha2h_nucleo"

backup_path="/home/gbcoha2h/Backups/Nucleo"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;
Comentario



########OPFDEMO##########

# Credenciales
user="gbcoha2h_opfdemo"
password="%Ky3KBBDdPnldemo"
host="localhost"
db_name="gbcoha2h_opfdemo"

backup_path="/home/gbcoha2h/Backups/Opfdemo"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;





########Siromax##########

# Credenciales
user="gbcoha2h_siromaxdb"
password='gbc0SKuKs$y0EoMV'
host="localhost"
db_name="gbcoha2h_siromax"

backup_path="/home/gbcoha2h/Backups/Siromax"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;




########WpGlobal##########

# Credenciales
user="gbcoha2h_wp_webg"
password="O&Xx8F0pPJq@9fi9"
host="localhost"
db_name="gbcoha2h_wpglobal"

backup_path="/home/gbcoha2h/Backups/Wpglobal"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;



########solucorp##########

# Credenciales
user="gbcoha2h_solucuser"
password="!v!Zn0TqtvzldpBN"
host="localhost"
db_name="gbcoha2h_solucorp"

backup_path="/home/gbcoha2h/Backups/solucorp"
date=$(date +"%d-%b-%Y")

# Crear Permisos
umask 177

#Rutina de Backup 
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql

#Comprimir el backup
cd $backup_path
tar -zcvf $db_name-$date.tar.gz $db_name-$date.sql

#eliminar original sql
rm -rf $backup_path/$db_name-$date.sql

#Borrar archivos > a 1 dia
find $backup_path/* -mtime +1 -exec rm {} \;