This script will enable you to backup your WordPress websites automatically. Just put it in a crontab / automatic scheduling software somewhere.
Also available on Pastebin : https://pastebin.com/nZ2fiL8j
Enjoy.
#!/bin/bash # wordpress-auto-backup.sh ### THIS SCRIPT ASSUMES THE FOLLOWING # 1/ You can do SSH password-less login to the server # How : https://easyengine.io/tutorials/linux/passwordless-authentication-ssh/ # 2/ You have created a correct ~/.my.cnf file # How : https://easyengine.io/tutorials/mysql/mycnf-preference/ ### RUNTIME PARAMETERS # wordpress-auto-backup.sh <server address> <home directory> <backup directory> ### HOW IT WORKS # 1/ SSH to server # 2/ read wp-config file & get details # 3/ create backup_dir/web # 4/ rsync home_dir backup_dir/web # 5/ backup database to backup_dir/web/today.mysql # 6/ compress backup_dir/web to backup_dir/backup_today.bz2 ### choose backup retention # backup retention: weekly today=`date +%A` # backup retention: monthly #today=`date +%d` compressor1='gzip' compressor2='pbzip2' #============= START BACKUP ======================= # to help making this code more readable server=$1 home_dir=$2 backup_dir=$3 # get the variables ssh $server "cat $home_dir/wp-config.php" > /tmp/$server$today.txt db_name=`cat /tmp/$server$today.txt | grep DB_NAME | cut -d"'" -f 4` db_user=`cat /tmp/$server$today.txt | grep DB_USER | cut -d"'" -f 4` db_pass=`cat /tmp/$server$today.txt | grep DB_PASSWORD | cut -d"'" -f 4` db_host=`cat /tmp/$server$today.txt | grep DB_HOST | cut -d"'" -f 4` table_prefix='' table_prefix=`cat /tmp/$server$today.txt | grep table_prefix | cut -d"'" -f 2` # debug #echo $db_name $db_user $db_pass $db_host $table_prefix # delete temporary file rm /tmp/$server$today.txt # backup database ssh $server "mysqldump -h $db_host -u $db_user --password=\"$db_pass\" $db_name \$(mysql -h $db_host -u $db_user --password=\"$db_pass\" -D $db_name -Bse \"show tables like '$table_prefix%'\") > $home_dir/db-$today.mysql" # compress database dump ssh $server "$compressor1 $home_dir/db-$today.mysql" # download everything mkdir $backup_dir/web/ rsync -avuz $server:$home_dir/* $backup_dir/web/ # make backup file tar cvf $backup_dir/$server-$today.tar $backup_dir/web/ $compressor2 $backup_dir/$server-$today.tar & # clean up ssh $server "rm $home_dir/db-$today.mysql.gz" # done !