Software: nginx/1.23.4. PHP/5.6.40-65+ubuntu20.04.1+deb.sury.org+1 

uname -a: Linux foro-restaurado-2 5.15.0-1040-oracle #46-Ubuntu SMP Fri Jul 14 21:47:21 UTC 2023
aarch64 

uid=33(www-data) gid=33(www-data) groups=33(www-data) 

Safe-mode: OFF (not secure)

/home/scripts/   drwxr-xr-x
Free 83.32 GB of 96.73 GB (86.14%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     backup_remoto.sh (778 B)      -rwxr-xr-x

#!/bin/bash
DB_host="173.212.218.215";
DB_port="8989"
DB_user="remoto"
DB_pass="p0rt0rp32009"
timeslot=`date +%Y%m%d_%H%M`
timeslot2=`date +%d-%m-%y`


# BBDD pesadas
incluir="
papyr225_phpb1
"
hora=`date +%H\\:%M`
for DB in $incluir
   do
   for t in $(mysql -NBA -h 127.0.0.1 -u papyr225_phpb1 -pbJ8V1vmDPkHZ -D $DB -e 'show tables')
      do
      hora=`date +%H\\:%M`
      echo "------- hora: $hora INICIO VolcaDO TABLA: $DB.$t ----------"

 mysqldump -h 127.0.0.1  -u papyr225_phpb1 -pbJ8V1vmDPkHZ --extended-insert --delayed-insert --single-transaction --lock-tables=false $DB $t |mysql -h 173.212.218.215 --port 8989 -u remoto  -pp0rt0rp32009 -D $DB





      hora=`date +%H\\:%M`
      echo "++++++++ hora: $hora FIN VolcaDO TABLA: $DB.$t +++++++++++"
   done
done