mysqlbackup.sh

#!/bin/sh

#############################
#### MySQL Backup Script ####
#############################

########## CONFIG ###########

OUTPUT_FOLDER="/home/server/DBbackup"
ROOT_USER="root"
ROOT_PASS=""

#############################

SUBFOLDER=`date '+%Y-%m'`

DATE_STR=`date '+%Y-%m'`_`date '+%a'`
BAKFILE=`echo "sqldump_$DATE_STR" | tr '[:upper:]' '[:lower:]'`
BAKFOLDER="$OUTPUT_FOLDER/$SUBFOLDER"

# create a sql dump
TMPFILE="$OUTPUT_FOLDER/$BAKFILE.sql"
OUTFILE="$BAKFOLDER/$BAKFILE.sql.xz"

mysqldump -u$ROOT_USER -p$ROOT_PASS --opt --all-databases > "$TMPFILE"

# make sure backup folder exists
if [ ! -d "$BAKFOLDER" ] ; then
  mkdir "$BAKFOLDER"
fi

# compress the backup
xz -c "$TMPFILE" > "$OUTFILE"

# cleanup
rm "$TMPFILE"