mysqldump的shell脚本如何搭建

下文主要给大家带来mysqldump的shell脚本如何搭建，希望这些内容能够带给大家实际用处，这也是我编辑mysqldump的shell脚本如何搭建这篇文章的主要目的。好了，废话不多说，大家直接看下文吧。

#!/bin/bash# Date:2017-10# Version:0.1# Description:db_user="root"myisam_db="mysql"db_passwd="123456"host="localhost"backup_dir="/opt/backup/mysql/sql"log_file="/opt/backup/mysql/sql/mysql_backup.log"keep_days=30mysql="$(which mysql)"mysqldump="$(which mysqldump)"db_list=$(mysql -h$host -u$db_user -p$db_passwd -e 'show databases'|egrep -v 'Database|information_schema|mysql|performance_schema')export PATH="/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin"dbs=$(echo $db_list|tr '\n' ' ')myisam_dump_file=$backup_dir/MyISAM-$(date +"%Y-%m-%d")-full.sql.gzinnodb_dump_file=$backup_dir/InnoDB-$(date +"%Y-%m-%d")-full.sql.gzold_file_myisam=$backup_dir/MyISAM-$(date --date="$keep_days days ago" +"%Y-%m-%d")-full.sql.gzold_file_innodb=$backup_dir/InnoDB-$(date --date="$keep_days days ago" +"%Y-%m-%d")-full.sql.gzinfo() {  if [ $? -eq 0 ];then    echo "Full backup $1 successfully." >>$log_file  else    echo "Full backup $1 failed." >>$log_file    echo "Full backup $1 failed."|mail -s "Full backup $2 failed" root@localhost  fi}delete_old_files() {if [ -f $1 ];then  rm -rf $1  echo "Delete old file '$1' successfully" >>$log_filefi}start_time=$(date +"%F %H:%M:%S")[ ! -d $backup_dir ] && mkdir -p $backup_dir[ ! -f $log_file ] && touch $log_fileecho "Starting mysql full backup database at $start_time" >>$log_file$mysqldump -h$host -u$db_user -p$db_passwd -F -B -x --events --triggers \--routines --master-data=2 $myisam_db|gzip >$myisam_dump_file 2>>$log_file info $myisam_dump_file "MyISAM"$mysqldump -h$host -u$db_user -p$db_passwd -F -B --single-transaction \--events --triggers --routines --master-data=2 $dbs|gzip >$innodb_dump_file 2>>$log_file info $innodb_dump_file "InnoBD"stop_time=$(date +"%F %H:%M:%S")echo "End mysql full backup database at $stop_time" >>$log_filedelete_old_files $old_file_myisamdelete_old_files $old_file_innodbecho " " >>$log_file

对于以上关于mysqldump的shell脚本如何搭建，大家是不是觉得非常有帮助。如果需要了解更多内容，请继续关注我们的行业资‍讯，相信你会喜欢上这些内容的。