#!/bin/sh

# mySQL Dump
SQLUSER=""
SQLPASSWORD=""
SQLDATABASE=""
FILE="backup.sql"

mysqldump -u $SQLUSER -p$SQLPASSWORD $SQLDATABASE > $FILE


# FTP Upload Info
USERNAME=""
PASSWORD=""
SERVER=""

# remote server directory to upload backup
BACKUPDIR=""

# login to remote server
ftp -n -i $SERVER <<EOF
user $USERNAME $PASSWORD
cd $BACKUPDIR
mput $FILE
quit
EOF