backup_wordpress.sh

#!/bin/sh

BACKUP_DIR=/dir/to/backup
SQL_FILE=backup.sql

mysqldump --skip-extended-insert --skip-dump-date \
        -uuser -ppwd database | 
        grep -v 'INSERT INTO `wp_statpress`' > $BACKUP_DIR/$SQL_FILE

rsync -ax /dir/to/wordpress/wp-content/themes/twentyten \
	  $BACKUP_DIR/twentyten

git --git-dir=$BACKUP_DIR/.git --work-tree=$BACKUP_DIR commit \
	-m "auto backup" $SQL_FILE twentyten