#!/bin/sh

# Declaire variables
USERNAME=""
PASSWORD=""
SERVER=""

# local directory to pickup file(s)
FILE="/path_to_file"

# remote server directory to upload file(s)
BACKUPDIR="/path_to_store_file"

# login to remote server
ftp -vni $SERVER <<EOD
quote USER $USERNAME
quote PASS $PASSWORD

# Change to required directories
cd $BACKUPDIR
lcd $FILE

# Put files
mput *.sql.gz

# End the session
quit
EOD
exit 0