#!/usr/bin/python#coding=utf-8'''@description: backup mysql zabbix databse@date:2013-08-07@ower:sunfuxing'''import osimport timemysql_comm = r'/usr/local/mysql/bin/mysqldump'mysql_user = 'zabbix'mysql_passwd = 'zabbix'mysql_bak_database = 'zabbix'bak_dir = '/root/backup/'log_file = open('/root/backup/mysql_zabbix.log','a')today = time.strftime('%Y-%m-%d')while True:    if os.path.exists(bak_dir):        bak_shell = '{0} -u{1} -p{2} {3} >{4}{5}.sql'.format(mysql_comm,mysql_user,\        mysql_passwd,mysql_bak_database,bak_dir,mysql_bak_database)        tgzfile = 'tar -zcvf {0}{1}.{2}.tar.gz  {3}{4}.sql 1>/dev/null 2>/dev/null'\        .format(bak_dir,mysql_bak_database,today,bak_dir,mysql_bak_database)        rm_file = 'rm -rf {0}{1}.sql'.format(bak_dir,mysql_bak_database)        os.system(bak_shell)        os.system(tgzfile)        os.system(rm_file)        print >>log_file,'{0} backup database sucess .....!'.format(today)        break    elif not os.path.exists(bak_dir):        os.mkdir(bak_dir)        print >>log_file,'backup dirctory create sucess.....!\n'    else:        print >>log_file,'{0} backup database bad......!'.format(today)log_file.close()