WordPress Backup

• http://wordpress.org/plugins/backupwordpress/

#!/bin/sh

WP_INSTANCE=wordpress

DBHOST=localhost
DBUSER=wordpress
DBNAME=wordpress
DBPASS=wordpress

PATH_TO_WP=/var/www/$WP_INSTANCE
DATE=$(date +%Y%m%d-%H%M)
FILENAME="backup-$WP_INSTANCE-$DATE.tar.bz2"

mysqldump -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME > data.sql

tar cjf $FILENAME data.sql $PATH_TO_WP

rm data.sql