#!/bin/bash
DIRECTORIO="$HOME/Sh"
#cd $DIRECTORIO
PROGRAMA=Respaldo_SQL_modelo.sh
SISTEMA=$1
DBASE=$2
DBASEdest=$3
TABLA=$4
CODIGO=$?
Graba_MYSQL $CODIGO 'INICIO'$DIRECTORIO/$PROGRAMA $SISTEMA
.
.
.
#!/bin/bash
CODIGO=$1
DATABASE='maestra'
DIRECTORIO=$2
FECHA=`date +%Y-%m-%d_%H.%M.%S`
PASSWORD='xxxxxxxxx'
PROGRAMA=$3
USUARIO='xxxxxx'
SALIDA="/tmp/$FECHA""_$PROGRAMA.sql"
SALIDA_OUT="/tmp/$FECHA""_$PROGRAMA""_OUT.sql"
VALUES="'$USER', '$DIRECTORIO', '$PROGRAMA', now()"
WHERE=' where `user` = '"'$USER'"' and `Programa` = '"'$PROGRAMA'"' and `Directorio` = '"'$DIRECTORIO'"
USE='USE `maestra`; insert into `numero de compilaciones x Programas` ( `user`, `Directorio`, `Programa`, `alta` ) values ( '$VALUES' )ON DUPLICATE KEY UPDATE `user` = '"'$USER'"';'
echo $USE > $SALIDA_OUT
MYSQL="mysql -u $USUARIO -p$PASSWORD $DATABASE < $SALIDA_OUT"
echo "#!/bin/bash" > $SALIDA
echo $MYSQL >> $SALIDA
chmod +x $SALIDA
echo $SALIDA
$SALIDA
if [ $CODIGO != 0 ]; then
USE='USE `'$DATABASE'`; update `numero de compilaciones x Programas` set `ejecucion fallida veces` = `ejecucion fallida veces` + 1, `ejecucion fallida` = now() '$WHERE' ;'
echo "codigo erroneo $CODIGO"
else
USE='USE `'$DATABASE'`; update `numero de compilaciones x Programas` set `ejecucion veces` = `ejecucion veces` + 1, `ejecucion` = now() '$WHERE' ;'
echo "codigo bien $CODIGO"
fi
echo $USE > $SALIDA_OUT
MYSQL="mysql -u $USUARIO -p$PASSWORD $DATABASE < $SALIDA_OUT"
echo "#!/bin/bash" > $SALIDA
echo $MYSQL >> $SALIDA
chmod +x $SALIDA
$SALIDA
mrco1965@debian:~$ sudo /etc/init.d/cron status
[sudo] password for mrco1965:
● cron.service - Regular background program processing daemon
Loaded: loaded (/lib/systemd/system/cron.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2018-09-19 11:20:57 CDT; 1h 52min ago
Docs: man:cron(8)
Main PID: 480 (cron)
Tasks: 1 (limit: 4915)
CGroup: /system.slice/cron.service
└─480 /usr/sbin/cron -f
sep 19 13:10:01 debian CRON[9802]: (CRON) info (No MTA installed, discardin…put)
sep 19 13:11:01 debian CRON[9830]: pam_unix(cron:session): session opened f…d=0)
sep 19 13:11:01 debian CRON[9831]: (mrco1965) CMD (~/bin/respaldoBD tabla m…ses)
sep 19 13:11:01 debian CRON[9830]: (CRON) info (No MTA installed, discardin…put)
sep 19 13:12:01 debian CRON[9854]: pam_unix(cron:session): session opened f…d=0)
sep 19 13:12:01 debian CRON[9855]: (mrco1965) CMD (~/bin/respaldoBD tablaL …tes)
sep 19 13:12:01 debian CRON[9854]: (CRON) info (No MTA installed, discardin…put)
sep 19 13:13:01 debian CRON[9893]: pam_unix(cron:session): session opened f…d=0)
sep 19 13:13:01 debian CRON[9894]: (mrco1965) CMD (~/bin/respaldoBD tablaL …ses)
sep 19 13:13:01 debian CRON[9893]: (CRON) info (No MTA installed, discardin…put)
Hint: Some lines were ellipsized, use -l to show in full.
mrco1965@debian:~$
@reboot crontab ~/Sh/crontab
59 * * * * /home/mrco1965/bin/respaldoBD local maestra
mrco1965@debian:~$ ls -la ../sandro/Respaldo_root
total 28
drwxr-xr-x 3 root root 4096 sep 18 14:29 .
drwxr-x--x 118 mrco1965 mrco1965 20480 sep 18 14:46 ..
drwxr-xr-x 2 root root 4096 sep 18 14:29 Mysql
mrco1965@debian:~$ ls -la ../sandro/Respaldo_root/Mysql
total 12112
drwxr-xr-x 2 root root 4096 sep 18 14:29 .
drwxr-xr-x 3 root root 4096 sep 18 14:29 ..
-rw-r--r-- 1 root root 6193168 sep 18 14:29 2018-09-18_14.29.03._.maestra..sql
-rw-r--r-- 1 root root 6193168 sep 18 14:29 bck.2018-09-18_14.29.03._.maestra..sql