Skip to content

Instantly share code, notes, and snippets.

@stephdl
Created December 11, 2021 18:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stephdl/6bb48dd680622d27d3cadc108dd08341 to your computer and use it in GitHub Desktop.
Save stephdl/6bb48dd680622d27d3cadc108dd08341 to your computer and use it in GitHub Desktop.
Openclassrooms TP9 OC AIC make a backup of wordpress and upload it by ftp
cd /tmp
echo "[+] backing up db"
mariabackup --backup --target-dir=/tmp/backupSQL --user=backup --password=backup
ndays=7
MM=`date --date="$ndays days ago" +%b`
DD=`date --date="$ndays days ago" +%d`
echo "[+] listing files in ftp"
cmd=`ftp -n 192.168.117.159 <<EOF
user rez hello1234
cd backup
ls
exit
EOF`
lister=( $cmd )
echo "[+] creating archive"
file_name="backupWP-$(date +'%md-%d-%y').tar.gz"
tar -czvf $file_name backupSQL /var/www/html/oc.com
rm -r backupSQL
echo "[+] Deleting file older than 7 days for rotation"
for ((FNO=0; FNO<${#lister[@]}; FN0+=9));do
if [ ${lister[`expr $FN0+5`]}=$MM ];
then
if [[ ${lister[`expr $FNO+5`]} -lt $DD ]];
then
ftp -n 192.168.117.159 <<EOF2
user rez hello1234
cd backup
delete ${lister[`expr $FN0+8`]}
exit
EOF2
fi
fi
done
echo "[+] Sending backup file to ftp"
ftp -n <<EOMYF
open 192.168.117.159
user rez hello1234
cd backup
put $file_name
exit
EOMYF
echo "[+] Done"
rm $file_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment