bash backup of webserver (FTP and SQL)

Quick and dirty backup from remote SQL and FTP server

Introduction

The following is a quick and dirty, simple implementation of a backup from mysql-db and ftp-available file area that . It uses git (though this is not really how git ought to be used), and transfers files securely, but not the database-dump. In other words, it got lots of potential for improvements.

Dependencies

•  lftp
• mysqldump
• git

The Code

#!/bin/bash

# START CONFIG
LOCAL_DIR="/home/user/backup/yourpath" # The local directory  
FTP_USR="ftp_username"                 # FTP user
FTP_PWD="ftp_password"                 # FTP password
FTP_HOST="ftp.server.com"              # FTP host
FTP_FOLDER="remote_folder"             # Folder on remote host
USING_SFTP=true                        # Use SFTP?
SQL_USR="sql_user"                     # SQL username
SQL_PWD="sql_password"                 # SQL password
SQL_DUMP_LOC="local_file.sql"          # name of SQL-dump file
SQL_HOST="sql.server.com"              # SQL host
DB_NAME="database_name"                # Name of database
DATE=`date +%Y-%m-%d`                  # Date format
# END CONFIG

cd $LOCAL_DIR

if [ "$USING_SFTP" = true ] ; then
 echo "Copying files through sftp..."
 lftp sftp://$FTP_USR:$FTP_PWD@$FTP_HOST -e "cd $FTP_FOLDER; mirror --only-newer; quit"2>ftp_log.txt
else
 echo "Copying files through unsecure ftp..."
 wget -mN ftp://$FTP_USR:$FTP_PWD@$FTP_HOST/$FTP_FOLDER 2>ftp_log.txt
fi

echo "Copying database unsecurely..."
mysqldump -h $SQL_HOST -u $SQL_USR -p$SQL_PWD $DB_NAME > $DATE.SQL_DUMP_LOC

echo "Committing..."
git add .
git commit -m "Scheduled backup $DATE"

Scheduling

See cron-tabs on how to set up this file to run every hour/day/week/month.