#!/bin/bash
############### Mysql Backup & FTP ################

#1. mkdir /home/mysqlbackup

#2. chmod 700 MysqlDatebackup.sh

#3. vi /etc/crontab , 30 03 * * * root /home/mysqlbackup/MysqlDatebackup.sh

#everyday 03:30 the MysqlDatebackup.sh will work
#System Setup

host=202.100.222.2 #ftp host

UserName=test #ftp user name

Passwd=test #fto user password
function Iint()

{

backup_path=/home/mysqlbackup #set saved backup path

file=$path-mysql-$(date +%Y-%m-%d).tar.gz

backupCWD=/usr/local/mysql/data/$path #set backup file,the mysql path

tar -czf $backup_path/$file $backupCWD

#file tar

cd $backup_path

#file ftp

ftp -i -n <<!

open $host

user $UserName $Passwd

if [ ! [ -d WEB-BACK/$path ]]; then

mkdir MYSQL-BACK/$path

fi

cd MYSQL-BACK/$path

put $file

bye

!

}

/etc/init.d/mysqld stop >/dev/null 2>&1

path=database1 #datebase1

Iint

path=datebase2 #datebase2

Iint

/etc/init.d/mysqld start >/dev/null 2>&1
rm -rf $backup_path/*.tar.gz

echo "ftp back ok!"