#!/bin/sh
# place into /etc/cron.daily/backup.sh
echo "Backuping..."

VERSION=$(date +%Y-%m-%d_%H:%M)
BACKUPS=/root/backups/$VERSIONS
mkdir -p $BACKUPS

echo "Dumping MySQL..."
mysqldump --host=localhost --user=backup --password=secret mydatabase > $BACKUPS/mydatabase.sql

echo "Setting permissions..."
chown -R root:root /root/backups
chmod -R o-r,o-w,o-x /root/backups

echo "Removing old backups..."
find /root/backups/ -type d -mtime +14 -exec rm -rf {} \;

echo "OK"
sleep 1