全息备份Mysql数据库

 #！/bin/bash

    
 # mysqldump.sh
    
  
    
 dbuser='root'   #数据库用户
    
 dbpasswd='123123'   #数据库密码
    
 dbname='dbname'     #需要备份的数据库
    
  
    
 backup_dir=/home/data/backup/mysql/   # 备份路径
    
 fileprefix=dbname-         # 备份文件名前缀
    
 backup_file=$backup_dir$fileprefix`date -d now +%Y%m%d`.sql
    
 tar_file=$backup_dir$fileprefix`date -d now +%Y%m%d`.tar.gz
    
  
    
 logfile=/home/data/backup/mysql/mysqlbackup.log
    
 logtmp=/home/data/backup/mysql/mybackup.tmp
    
  
    
 [ ! -d