wordpress-backup.sh

wordpress-backup.sh

#!/bin/bash
 
NOW=$(date +"%Y-%m-%d-%H%M")
 
DB_USER="dbuser"
DB_PASS="dbpass"
DB_NAME="database_name"
DB_HOST="127.0.0.1"
 
TREE_FILE="$NOW.tar.gz"
DB_FILE="$DB_NAME.$NOW.sql.tar.gz"
 
BACKUP_DIR="/www-backups/$NOW"
WWW_DIR="/var/www/path/to/wp/site"
 
mkdir -p $BACKUP_DIR
tar -czvf $BACKUP_DIR/$TREE_FILE $WWW_DIR
 
mysqldump -h$DB_HOST -u$DB_USER -p$DB_PASS $DB_NAME --skip-add-locks > /tmp/$DB_NAME
tar -czvf $BACKUP_DIR/$DB_FILE /tmp/$DB_NAME
rm /tmp/$DB_NAME