学步园

用Python写了一个定时备份Mysql的脚本，Python的好处就是代码简单，而且一看就懂。

这个程序基本上改改基本的配置，就能完成绝大多数的Mysql定期备份的需求了。

把代码贴在下面：

#! /usr/bin/env python<br /> #coding=utf-8<br /> """<br /> 本程序用于每日备份牧场数据库<br /> 1、备份Mysqldump每日的数据库<br /> 2、讲备份出来的数据库文件进行压缩<br /> 3、删除已压缩的原始文件<br /> 4、删除15天前生成的压缩文件<br /> author:kunp<br /> email:coonxu@gmail.com<br /> date:2010-08-14<br /> """<br /> import datetime<br /> import os<br /> StrBackupDir = "/data/dbbak/"<br /> StrBackupFile = "zoo"<br /> StrBackupCMD = "mysqldump -h127.0.0.1 -P3306 zoo > "<br /> StrTarCMD = "tar cvzf "<br /> IntOlddayCount = 15<br /> if __name__ == '__main__':<br /> #get the file name for yesterday<br /> today = datetime.date.today( )<br /> yesterday = today - datetime.timedelta( days = 1 )<br /> strSqlFile = StrBackupFile + str( yesterday ) + ".sql"</p> <p> strSqlFile = StrBackupDir + strSqlFile<br /> strBackupCMD = StrBackupCMD + strSqlFile<br /> print strBackupCMD</p> <p> #mysqldump the DB to the new sql file<br /> os.system( strBackupCMD )</p> <p> #tar the sql file to the zip file<br /> strTarFile = StrBackupFile + str( yesterday ) + ".tar.gz"<br /> strTarFile = StrBackupDir + strTarFile<br /> strTarCMD = StrTarCMD + strTarFile + " " + strSqlFile<br /> print strTarCMD</p> <p> #execute the tar cmd<br /> os.system( strTarCMD )</p> <p> #rm the sql file after zip<br /> strDelSqlCMD = "rm " + strSqlFile<br /> print strDelSqlCMD</p> <p> #execute the del cmd<br /> os.system( strDelSqlCMD )</p> <p> #rm the old zip file which is born 15 days ago<br /> oldday = today - datetime.timedelta( days = IntOlddayCount )<br /> strOldTarFile = StrBackupFile + str( oldday ) + ".tar.gz"<br /> strOldTarFile = StrBackupDir + strOldTarFile<br /> strDelOldTarCMD = "rm " + strOldTarFile<br /> print strDelOldTarCMD</p> <p> #execute the del old zip file cmd<br /> os.system( strDelOldTarCMD )<br />