Shulou(Shulou.com)06/01 Report--

The following mainly brings you how to build the shell script of mysqldump. I hope this content can bring you practical use, which is also the main purpose of how to build this article when I edit the shell script of mysqldump. All right, don't talk too much nonsense, let's just read the following.

#! / bin/bash# Date:2017-1 "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

For the above about how to build the shell script of mysqldump, do you find it very helpful? If you need to know more, please continue to follow our industry capital ‍ news, I believe you will like this content.

How to build the shell script of mysqldump

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.