WordPress Backup via wp-cli & rsync

wp-backup.sh

#!/usr/bin/env bash
#
#  Will output a list of commands to backup WordPress web-root + Database:
#  This script won't execute the commands, so you can review them before executing.
#
#  Requirements: wp-cli, rsync
#
#   1. create backup folder based on date
#   2. backup WordPress DB via wp-cli
#   3. backup WordPress web-root via rsync
#   4. tar + gzip backup folder
#   5. remove backup folder
#   6. output a list of backups older than X days
#
#  Variables to set:
#
#   BACKUP_BASE_PATH: Base path to your backups. Commands will generate yymmdd_backup.tar.gz files inside this directory.
#   WP_HTTP_PATH: Path to WordPress-Installation
#   WPCLI_PATH: Path to wp-cli executable
#   BACKUP_KEEP_DAYS: Output files older than ${BACKUP_KEEP_DAYS} days - you may want to remove or archive these files.
#   BACKUP_PREFIX: Name for your backup e.g. "sitename" => files are named "yymmdd-HHMMSS_sitename.tar.gz"
#
#  Example output:
#
#  # Command to create backup folders:
#  mkdir -p "/home/myname/backups/180829/db" "/home/myname/backups/180829/wp"
#
#  # Command to backup WordPress DB:
#  /usr/local/wp --path="/var/www/my-wordpress-blog.com" db export "/home/myname/backups/180829/db/my-wordpress-blog_180829.sql"
#
#  # Command to backup WordPress web-root-folder:
#  rsync -Cavz --no-o --no-g --omit-dir-times --delete --exclude=".DS_Store" "/var/www/my-wordpress-blog.com/" "/home/myname/backups/180829/wp/"
#
#  # Command to compress backup folder:
#  tar -zcvf  "/home/myname/backups/180829-115405_my-wordpress-blog.tar.gz" "/home/myname/backups/180829"
#
#  # Command to remove backup folder:
#  rm -r "/home/myname/backups/180829"
#
#  # Command to find backups older than 10 days:
#  find /home/myname/backups -type f -name '*.tar.gz' -mtime +10
#
#  =====================
#  Use at your own risk!
#  =====================

BACKUP_BASE_PATH=""
WP_HTTP_PATH=""

BACKUP_KEEP_DAYS="10"

WPCLI_PATH=""

BACKUP_PREFIX=""

BACKUP_DATE="$(date '+%y%m%d')"
BACKUP_TIME="$(date '+%H%M%S')"

BACKUP_PATH_DATE="${BACKUP_BASE_PATH%/}/${BACKUP_DATE}"
BACKUP_PATH_DB="${BACKUP_PATH_DATE%/}/db"
BACKUP_PATH_WP="${BACKUP_PATH_DATE%/}/wp"

BACKUP_DB_FILENAME="${BACKUP_PATH_DB%/}/${BACKUP_PREFIX}_${BACKUP_DATE}.sql"
TAR_FILENAME="${BACKUP_BASE_PATH%/}/${BACKUP_DATE}-${BACKUP_TIME}_${BACKUP_PREFIX}.tar.gz"

BACKUP_DIR_CMD="mkdir -p \"${BACKUP_PATH_DB}\" \"${BACKUP_PATH_WP}\""



BACKUP_DB_CMD="${WPCLI_PATH} --path=\"${WP_HTTP_PATH%/}\" db export \"${BACKUP_DB_FILENAME}\""

RSYNC_CMD="rsync -Cavz --no-o --no-g --omit-dir-times --delete --exclude=\".DS_Store\" \"${WP_HTTP_PATH%/}/\" \"${BACKUP_PATH_WP%/}/\""


TAR_CMD="tar -zcvf  \"${TAR_FILENAME}\" \"${BACKUP_PATH_DATE}\""

RM_BACKUP_DIR_CMD="rm -r \"${BACKUP_PATH_DATE}\""

FIND_CMD="find ${BACKUP_BASE_PATH} -type f -name '*.tar.gz' -mtime +${BACKUP_KEEP_DAYS}"

echo -e "\n# Command to create backup folders:"
echo -e "${BACKUP_DIR_CMD}"
echo -e "\n# Command to backup WordPress DB:"
echo -e "${BACKUP_DB_CMD}"
echo -e "\n# Command to backup WordPress web-root-folder:"
echo -e "${RSYNC_CMD}"
echo -e "\n# Command to compress backup folder:"
echo -e "${TAR_CMD}"
echo -e "\n# Command to remove backup folder:"
echo -e "${RM_BACKUP_DIR_CMD}"
echo -e "\n# Command to find backups older than ${BACKUP_KEEP_DAYS} days:"
echo -e "${FIND_CMD}"