韶华岁月

#!/bin/bash
#
######################################
# Purpost: Auto backup file by ftp
# Author: Kook.liu , E-Mail ( qsblj AT yahoo DOT com)
# From: LinuxFans
######################################
# Below use ftp
######################################
#filename=$1

# backup file
DBNameA=bugfree_`date +%Y-%m-%d`.sql
DBNameB=mantis_`date +%Y-%m-%d`.sql
DBNameC=timelog_db_`date +%Y-%m-%d`.sql
DBNameD=testlink_`date +%Y-%m-%d`.sql
DBNameE=ks_com_`date +%Y-%m-%d`.ldif


# backup locate
DBAPath=$HOME/backup/bugfree
DBBPath=$HOME/backup/mantis
DBCPath=$HOME/backup/timelog
DBDPath=$HOME/backup/testlink
DBEPath=$HOME/backup/ldap

# svn path
#svn_path=$HOME/Database

#backup mysql fund_db
mysqldump -ubugfree -pdb_bugfree BugFree > "$DBAPath/$DBNameA"
mysqldump -umantis -pdb_mantis mantis > "$DBBPath/$DBNameB"
mysqldump -utimelog -pdb_timelog timelog_db > "$DBCPath/$DBNameC"
mysqldump -utestlink -pdb_testlink TestLink > "$DBDPath/$DBNameD"
/usr/sbin/slapcat -f /etc/ldap/slapd.conf -b "dc=ksthiz,dc=com" > "$DBEPath/$DBNameE"

# svn sync
#cp $backup_path/$mysqlbak_name $svn_path
#cd $svn_path
#svn add $mysqlbak_name
#svn ci -m "add mysql.sql update everyday"
#cd $BackPath

# up backup file
ftp -nv << !
open 192.168.101.250
user backup backup
binary
cd mysql
put $DBNameA
put $DBNameB
put $DBNameC
put $DBNameD
put $DBNameE
close
bye
#
exit 0
!# del package_name
rm $package_name -f
########################################