#mysql
/usr/local/mysql/bin/mysqldump --skip-extended-insert --default-character-set=gbk -uroot -ppwd dbname | gzip -c -9 > /data/backup/db/dbname_`date +%y%m%d`.gz

#删除8天以前的文件
/usr/bin/find /data/backup/db/ -ctime +8 -exec rm {} \;

#hotcopy 备份数据库
/usr/local/mysql/bin/mysqlhotcopy -u root -p pwd dbname /data/backup/db/090805/

python写的数据库备份：

#!/usr/bin/env python
import time
import os
 
dbs = ['forum', 'tech', 'life', 'comm',
    'survey', 'ucenter']
 
path = "/data/backup/db/%s/" % time.strftime("%y%m%d")
if not os.path.exists(path):
    os.mkdir(path)
 
for db in dbs:
    cmd = "/usr/local/mysql/bin/mysqlhotcopy -u root -p pwd %s %s" % (db, path)
    os.system(cmd)

import ftplib
 
ftphost = "ip"
ftpuser = "user"
ftppwd = "pwd"
ftpmode = 1
 
ftp=ftplib.FTP(ftphost, ftpuser, ftppwd)
ftp.set_pasv(ftpmode)
ftp.cwd('dir')
 
filepath = "/data/aaa.tar.gz"
f = open(filepath, 'rb')
ftp.storbinary("STOR %s " % os.path.basename(filepath), f)
f.close()
 
ftp.quit()

#!/bin/bash
serverip="IP"
username="username"
password="password"

echo $DATE
echo $serverip
echo $username
echo $password

source="/data/backup/${DATE}.文件扩展名"
dest="/RECYCLER/fee.sicau.edu.cn/${DATE}.文件扩展名"

echo $source
echo $dest

ftp -nvi << open $serverip
user $username $password
bin
prompt
put $source $dest
close
bye