DBbinPath=/usr/bin/
DBName=emall
DBUser=emall
DBPassword=bAKREm5wy4276MYA
BackupPath=/home/nio/emall_db
CscmdPath=/home/nio/sndatool
TIMESTAMP=`date "+%Y-%m-%d-%H"`
BACKFILE="emall_${TIMESTAMP}"
Sql="${BACKFILE}.sql"
Zip="${BACKFILE}.zip"

cd ${BackupPath};
#dump sql file
mysqldump --user=${DBUser} --password=${DBPassword} ${DBName} > ${Sql};

#zip sql file
zip ${Zip} ${Sql};

#push zip file into snda
${CscmdPath}"/"cscmd put ${Zip} cs://niobackup;

#rm old files
find ${BackupPath}"/" -mtime +6 -exec rm {} \;