Dump DB – Dump HTML Dir – Scripts
Dump DB
#!/bin/bash
var=$(date +”%FORMAT_STRING”)
now=$(date +”%d_%m_%Y_%H_%M”)
printf “%s\n” $now
today=$(date +”%Y-%m-%d-%H-%M”)
printf “Dumping…”
mysqldump wordpress > /root/Dumps/SiteName${today}.sql
printf “Compressing…”
zip /root/Dumps/SiteName${today}.zip /root/Dumps/WeeCanna${today}.sql
printf “Removing SQL File…”
rm /root/Dumps/WeeCanna${today}.sql
printf “Sending…”
sftp -P 21098 [email protected]:/home/user/wcdbbk <<< $’put /root/Dumps/SiteName${today}’.zip’
printf “Done.”
Dump HTML Dir
#!/bin/bash
var=$(date +”%FORMAT_STRING”)
now=$(date +”%d_%m_%Y_%H_%M”)
printf “%s\n” $now
today=$(date +”%Y-%m-%d-%H-%M”)
printf “Dumping And Compressing HTML…”
zip -9 -r /root/Dumps/SiteNameHTML${today}.zip /var/www/wordpress
printf “Sending…”
sftp -P 21098 [email protected]:/home/weecbsij/wcdbbk <<< $’put /root/Dumps/SiteNameHTML’${today}’.zip’
printf “Done Uploading.”
rm /root/Dumps/SiteNameHTML${today}.zip
printf “Removed Local File”