Storing WordPress files and database with WP-CLI on the server.

README.md

WordPress Backups with WP-CLI and TAR

The paths used may be server specific. Adjust accordinarly. Simple commands and bash scripts useful for quick backups of Wordpress.

backup.sh

#!/bin/sh

/usr/local/bin/wp db --path=/var/www/websites/wp - | gzip > /var/www/backups/db_backup-$(date +%Y-%m-%d-%H%M%S).sql.gz &
tar --create --gzip --absolute-names --file=/var/www/backups/wp_backup-$(date +%Y-%m-%d-%H%M%S).tar.gz --exclude=*.tar.gz /var/www/websites/wp

backup_pre-update.sh

#!/bin/sh
tar -czf ~/wp-backups/plugins-$(date +%Y-%m-%d-%H%M%S).tar.gz ~/httpdocs/wp-content/plugins
echo "Plugins backed up. Now doing themes."
tar -czf ~/wp-backups/themes-$(date +%Y-%m-%d-%H%M%S).tar.gz ~/httpdocs/wp-content/themes
echo "Themes backed up. Now doing database."
wp db export - | gzip > ~/wp-backups/db_backup-$(date +%Y-%m-%d-%H%M%S).sql.gz
echo "Database backed up"

crontab

30 18 * * * sh /var/www/backups/backup.sh > /var/www/logs/cronlog 2>&1

db_backup.sh

#!/bin/sh

wp db export - | gzip > ./db_backup-$(date +%Y-%m-%d-%H%M%S).sql.gz

wp_backup.sh

#!/bin/sh

tar --create --gzip --verbose --absolute-names --file=./wp_backup-$(date +%Y-%m-%d-%H%M%S).tar.gz --exclude=*.tar.gz /var/www/websites/wp