উন্নত ওয়েব সার্ভার ম্যানেজার

✏️ Editing: wpdatabasebkup.ssh

#!/bin/bash
#Code below is to take backup of asmitasolutions wordpress database
export DATE=`date +"%d_%b_%Y_%H%M"`
export DATABASE1=asmitasolwpdb
export SQLFILE1=/home/k0934d669o2b/websites/WPdatabase/${DATE}$DATABASE1.sql

/usr/bin/mysqldump -u 'asmitasolwp' -p'w!t#0H@m' --single-transaction $DATABASE1 > $SQLFILE1
/usr/bin/gzip $SQLFILE1 > /home/k0934d669o2b/cronoutput/$DATABASE1.gzipout.txt 2> /home/k0934d669o2b/cronoutput/$DATABASE1.gziperror.txt

#Code below is to take backup of vidyarjanconsulting wordpress database
export DATABASE2=vdworpressDB
export SQLFILE2=/home/k0934d669o2b/websites/WPdatabase/${DATE}$DATABASE2.sql

/usr/bin/mysqldump -u 'vidyarjanwpadmin' -p'?s9XgIk5' --single-transaction $DATABASE2 > $SQLFILE2
/usr/bin/gzip $SQLFILE2 > /home/k0934d669o2b/cronoutput/$DATABASE2.gzipout.txt 2> /home/k0934d669o2b/cronoutput/$DATABASE2.gziperror.txt

#Code below is to take backup of vidyarjan wordpress database
export DATABASE3=vidyarjanwpdb
export SQLFILE3=/home/k0934d669o2b/websites/WPdatabase/${DATE}$DATABASE3.sql

/usr/bin/mysqldump -u 'vidyarjanwpadmin' -p'?s9XgIk5' --single-transaction $DATABASE3 > $SQLFILE3
/usr/bin/gzip $SQLFILE3 > /home/k0934d669o2b/cronoutput/$DATABASE3.gzipout.txt 2> /home/k0934d669o2b/cronoutput/$DATABASE3.gziperror.txt

#Code below is to take backup of daksham wordpress database
export DATABASE4=dakshamdb
export SQLFILE4=/home/k0934d669o2b/websites/WPdatabase/${DATE}$DATABASE4.sql

/usr/bin/mysqldump -u 'dakshamuser' -p'dP&I$1xQ' --single-transaction $DATABASE4 > $SQLFILE4
/usr/bin/gzip $SQLFILE4 > /home/k0934d669o2b/cronoutput/$DATABASE4.gzipout.txt 2> /home/k0934d669o2b/cronoutput/$DATABASE4.gziperror.txt

#Code below is to delete the files from backup dated 30 days older
/usr/bin/find /home/k0934d669o2b/websites/WPdatabase/* -mtime +10 -type f -delete

🚀 Advanced Web Server Manager