Setting up the script on a local machine

• Windows
• Linux and MacOS

• Using cPanel
• Using the shell

Using cPanel

#!/usr/bin/env bash
NAMEDATE=`date +%F_%H-%M_%s`_`whoami`
mkdir ~/backup/$NAMEDATE -m 0755
mysqldump -u dbusername -p"dbpassword" dbname | gzip > ~/backup/$NAMEDATE/db.sql.gz
tar czf ~/backup/$NAMEDATE/files.tar.gz ~/public_html
chmod -R 0644 ~/backup/$NAMEDATE/*
exit 0

• Replace dbusername with the actual database username (weâ$™ve used nctest_production as an example). This can be checked in your websiteâ$™s config file or in the MySQL Databases menu.
• Replace dbpassword with the actual password for the selected database user. Note that there is no space between -p and the password itself.
• Replace dbname with the name of the database.

• Minute: 30
• Hour: 0
• Day: *
• Month: *
• Weekday: 1,4
• Command:

  /bin/bash ~/backup/backup_server.sh 2>&1

• Minute: 0
• Hour: 0
• Day: *
• Month: *
• Weekday: 0
• Command:

  cd ~/backup; find . -type d -mtime +7 -exec rm -rf {} \; 2>&1

Using the shell

mkdir ~/backup
touch ~/backup/backup_server.sh

chmod 0755 ~/backup/backup_server.sh

cd backup
nano backup_server.sh 

#!/usr/bin/env bash
NAMEDATE=`date +%F_%H-%M_%s`_`whoami`
mkdir ~/backup/$NAMEDATE -m 0755
mysqldump -u dbusername -p"dbpassword" dbname | gzip > ~/backup/$NAMEDATE/db.sql.gz
tar czf ~/backup/$NAMEDATE/files.tar.gz ~/public_html
chmod -R 0644 ~/backup/$NAMEDATE/*
exit 0

• dbusername - replace it with the actual database username (weâ$™ve used nctest_production as an example). It can be checked in your websiteâ$™s config file or in the MySQL Databases menu.
• dbpassword - replace it with the actual password for the aforementioned database user. Note that there is no space between -p and the password itself.
• dbname - replace it with the name of the database.

(crontab -l ; echo "30 0 * * 1,4 ~/backup/backup_server.sh > /dev/null 2>&1") | sort - | uniq - | crontab -

(crontab -l ; echo "0 0 * * 0 cd ~/backup; find . -type d -mtime +7 -exec rm -rf {} \; >/dev/null 2>&1") | sort - | uniq - | crontab -

sh backup_server.sh

Setting up the script on a local machine

ssh-keygen

Windows

• PuTTY should be installed on your machine to the default path (Program Files).
• You should have your private SSH key converted to a PPK format (the one PuTTY understands) and stored locally. This key should not have a passphrase.
• You should connect to your account via SSH at least once so PuTTY remembers the serverâ$™s fingerprint. Otherwise, the backup script will fail.

@ECHO OFF
SET PATH=â$%PROGRAMFILES%â$\PuTTY;%PATH%
SET PKEY=\path\to\private\key.ppk
>backup_client.temp plink.exe -i %PKEY% -t -P 21098 username@servername "ls -thl ~/backup | grep ^d | head -n 1 | awk '{print $9}'"
FOR /f "delims=" %%x IN (backup_client.temp) DO SET DTNM=%%x
pscp.exe -q -scp -batch -r -i %PKEY% -P 21098 username@servername:/home/username/backup/%DTNM% .
del /f backup_client.temp

• Replace the \path\to\private\key.ppk with the actual value, including the .ppk file extension (weâ$™ve used C:\Users\user\private.ppk as an example).
• username and servername are to be changed to the actual ones throughout the script.
• If PuTTY is installed to a non-default path, change %PROGRAMFILES%\PuTTY to the actual directory.

C:\Windows\System32\taskschd.msc

Linux and MacOS

#!/usr/bin/env bash
ssh -i ~/.ssh/id_rsa -t -p21098 username@servername "ls -thl ~/backup" > backup_client.temp 2>&1
scp -r -i ~/.ssh/id_rsa -P 21098 username@servername:~/backup/`grep ^d backup_client.temp | head -n 1 | awk '{print $9}'` .
rm -f backup_client.temp

chmod +x ~/backup/backup_client.sh

(crontab -l ; echo "30 1 * * 1,4 /path/to/backup/dir/backup_client.sh > /dev/null 2>&1") | sort - | uniq - | crontab -