Regelmäßig MySQL-Datenbank sichern

ftp)

echo -e "open -u ${FTPUSER},${FTPPASSWD} ${FTPHOST}\nmkdir ${FTPBASE}\nput -E -O ${FTPBASE} ${FN}.bz2" | \
lftp -f /dev/stdin >/dev/null 2>&1

test ! "$?" = "0" && echo "Uploading $FN failed."
;;

mail)

BOUNDARY="nextpart$$"

(echo "Mime-Version: 1.0"
echo "Content-Type: Multipart/Mixed; Boundary=\"$BOUNDARY\""
echo "Content-Transfer-Encoding: 7bit"
echo "To: $ADDRESS"
echo "From: $FROM"
echo "Subject: $SUBJECT"
echo ""
echo "This is a multi-part message in MIME format."
echo "--$BOUNDARY"
echo "Content-Type: text/plain; charset=ISO-8859-15; format=flowed"
echo "Content-Transfer-Encoding: 7bit"
echo ""
echo "Anbei die Sicherung der Datenbank $DATABASE"
echo ""
echo "--$BOUNDARY"
echo "Content-Type: application/x-bzip2; name=\"$FN.bz2\""
echo "Content-Transfer-Encoding: base64"
echo "Content-Disposition: attachment; filename=\"$FN.bz2\""
echo ""

/usr/bin/uuencode -m $FN.bz2 $FN.bz2 | grep -E -v "^begin|^====$"

echo ""
echo "--$BOUNDARY--"
echo "") | sendmail -f$FROM -oi $ADDRESS

test ! "$?" = "0" && echo "Mailing $FN failed."
;;

*)

echo "Usage: $0 [mail|ftp] database user password [address|host user password [base]]"