Backup html and databases

README.md

Add this file to crontab using crontab -e. There is a online generator: https://crontab-generator.org/

Use Task Scheduler on Windows 10 to execute the script: https://active-directory-wp.com/docs/Usage/How_to_add_a_cron_job_on_Windows.html

backup.cmd

@echo off
rmdir /S / Q <target-folder>
pscp -P <port> -pw <password> -r <user>@<host>:<source-folder> <target-folder>

:: Example:
:: pscp -P 12345 -pw 1234 -r root@z3nth10n.net:/var/ftp/backup-admin debian-mv-z3nth10n-net

backup.sh

#!/bin/bash
# https://stackoverflow.com/questions/19904992/mysqldump-without-password-in-crontab

rm /var/ftp/backup-admin/backup.tar.gz
rm /var/ftp/backup-admin/.bash_history
rm -rf /var/ftp/backup-admin/logs
tar czf /var/ftp/backup-admin/backup.tar.gz /var/www
cp ~/.bash_history /var/ftp/backup-admin/bash_history
cp -R /var/log/apache2 /var/ftp/backup-admin/logs
mysqldump --defaults-extra-file="/var/crons/mysql/.database.cnf" -u administrador --all-databases > /var/ftp/backup-admin/all_databases.sql