Tiny shell script to backup WordPress on Dropbox. Schedule this script with cron and you'r done.

wpbackup.sh

#!/bin/sh
NAME="blogname"
DIR="/var/www/blogfolder"
SQL="blogdatabase"
U="dbuser"
P="dbpassword"

NOW=$(date +"%m_%d_%Y")
FILE="$NAME.$NOW.tar.gz"
TARGET="/root/Dropbox/Backup/$FILE"

rm -Rf /tmp/wpbackup_$NAME
mkdir /tmp/wpbackup_$NAME
cd /tmp/wpbackup_$NAME

mysqldump --add-drop-table -u$U -p$P $SQL > $SQL.sql
cp $DIR . -Rf
tar -pczf $FILE .
mv $FILE $TARGET