#!/bin/bash

DUMP_FILE=~/`date +%Y%m%d`_MySQL_Dump.sql.bz2

echo "dump file: '${DUMP_FILE}'"

if [ -e ${DUMP_FILE} ] ; then
    echo
    echo "SQL Dump existiert schon! Erneut erzeugen? (j/n)"
    read -n 1 TASTE
    if [ ! "${TASTE}" == "j" ] ; then
        echo "Abbruch..."
        exit 1
    fi
fi

echo erstelle ${DUMP_FILE} ...
mysqldump --password=DEIN_PASSWORT DB_NAME | bzip2 > ${DUMP_FILE}