#!/bin/bash
#Ftp Informaition
Host=219.155.199.206
Username=e00021
Passwd=6418806lipg

#start mysqldump back
/usr/local/mysql/bin/mysqldump -uroot -p7695631 a1m > $(date +%Y%m%d)-a1m.sql
/usr/local/mysql/bin/mysqldump -uroot -p7695631 Asia1Market > $(date +%Y%m%d)-Asia1Market.sql
#/usr/local/mysql/bin/mysqldump -uroot -p7695631 mysql > $(date +%Y%m%d)-mysql.sql
#/usr/local/mysql/bin/mysqldump -uroot -p7695631 test > $(date +%Y%m%d)-test.sql
#/usr/local/mysql/bin/mysqldump -uroot -p7695631 cluster > $(date +%Y%m%d)-cluster.sql

#start tar all .sql file into one compressed file
tar -zcvf $(date +%Y%m%d)-mysql.tar.gz ./$(date +%Y%m%d)*.sql

#start ftp to remote server ( from linux to suntrust )
echo "open $Host
      user $Username $Passwd
      bin
      cd ./mysqlbak    //change directory to mysqlbak 
      prompt off
      mput $(date +%Y%m%d)-mysql.tar.gz    // place mysql.tar.gz into folder
      printf "\n" 
      close
      bye"|ftp -i -n

#start del teh old file 
rm -rf $(date +%Y%m%d)-a1m.sql  $(date +%Y%m%d)-Asia1Market.sql $(date +%Y%m%d)-mysql.tar.gz

    Source: geocities.com/lim_abc