Super Simple Backup System, a very simple system to automatically backup mysql and ftp.

ftpbackup.sh

#!/bin/bash
OUTDIR=$1
BACKUP=$OUTDIR/tmp
NOW=$(date +"%d-%m-%Y")

# clean up tmp dir
rm -f -r $BACKUP/*

# backup a folder of a website
FILE=fs-rootfolder-full.$NOW
mkdir $BACKUP/$FILE
wget -P $BACKUP/$FILE -m --user yourftpusername --password "yourftppassword" ftp://hostname.tld/webfolder/ && tar cvzf $OUTDIR/ftp/$FILE.tar.gz $BACKUP/$FILE

# backup another folder of a website
# FILE=fs-another_folder-full.$NOW
# mkdir $BACKUP/$FILE
# wget -P $BACKUP/$FILE -m --user yourftpusername --password "yourftppassword" ftp://hostname.tld/anotherfolder/ && tar cvzf $OUTDIR/ftp/$FILE.tar.gz $BACKUP/$FILE

# remove old backup
# retention is set to 9 days
find $OUTDIR/ftp/ -mtime +9 -exec rm {} \;

# clean up tmp dir
rm -f -r $BACKUP/*

mysqlbackup.sh

#!/bin/bash
OUTDIR=$1
NOW=$(date +"%d-%m-%Y")

# mysql backup of a db
FILE=mysql-dbname.$NOW-$(date +"%T").sql
mysqldump -h hostname.tld -u mysql_user -pmysqlpassword --opt dbname > $OUTDIR/mysql/$FILE
tar cvzf $OUTDIR/mysql/$FILE.tar.gz $OUTDIR/mysql/$FILE
rm $OUTDIR/mysql/$FILE

# mysql backup of another db
# FILE=mysql-anotherdbname.$NOW-$(date +"%T").sql
# mysqldump -h hostname.tld -u mysql_user -pmysqlpassword --opt anotherdbname > $OUTDIR/mysql/$FILE
# tar cvzf $OUTDIR/mysql/$FILE.tar.gz $OUTDIR/mysql/$FILE
# rm $OUTDIR/mysql/$FILE

# remove old backup
# retention is set to 15 days
find $OUTDIR/mysql/* -mtime +15 -exec rm {} \;

You can read this blog post to understand how to use these files.

Cheers!