Skip to content

Instantly share code, notes, and snippets.

@orhanveli

orhanveli/wordpress-backup.sh

Created July 5, 2017 08:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save orhanveli/82351a13ffaa1c374be3621e51d6288d to your computer and use it in GitHub Desktop.
Save orhanveli/82351a13ffaa1c374be3621e51d6288d to your computer and use it in GitHub Desktop.
Download ZIP
wordpress-backup.sh
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment