#!/bin/sh
USERNAME="your-ftp-user-name"
PASSWORD="your-ftp-password"
SERVER="your-ftp.server.com"

# local directory to pickup *.tar.gz file
FILE="/tmp/backup"

# remote server directory to upload backup
BACKUPDIR="/pro/backup/sql"

ftp -n -i -p $SERVER << EOF
user $USERNAME $PASSWORD
cd $BACKUPDIR
lcd $FILE
mput *
quit

EOF