WordPress backup script

wp-backup.sh

#!/bin/sh
# Automatically create WordPress database backups every week

# Delete old backups
cd /home/protected
echo "Deleting backups older than 30 days..."
find ./ -mtime +30 -type f -name '*.sql.gz' -print -delete

# Create the backup
now=$(date +"%Y_%m_%d")
echo "Saving database backup $now.sql..."

cd ../public/
wp db export $now.sql
mv $now.sql ../protected/
cd ../protected/
gzip $now.sql

# echo "WordPress DB backup saved!"
# WordPress prints its own success message.