mysql backup shell script

#!/bin/bashif [$]thenbackup_level=$1elsebackup_level=0fibackup_user=sysbackup_user_pw=oracle#catalog_user=rman #catalog_user_pw =rmanlog_file=/oracle/admin/$ORACLE _sid/rman_backup.logecho "Beginning rman backup ..." > $log _ filedata>> $log _filerman target $backup _user/$backup _user_pw Shell

Tags: mysql scheduled backup script diary cutMost of the diary cutting and backup mechanisms are the same: The following is the Nginx diary cutting script#!/bin/bashLogPath = '/home/nginx/log 'Nglogs = '/opt/nginx/logsMkdir-p $logpath/$ (date +%y)/$ (date +%m)MV $nglogs/acce

#!/bin/sh#please user the full Path DirectorySitename= "Www.sijisiji.com"prefix= ' Date +%y%m%d 'Cur_bak_name=${sitename} "_" ${prefix} "_bak"Cur_bak_name_gz=${cur_bak_name} ". tar.gz"Backupdir= "/home/backup"Sitedir= "/home/wwwroot"if [!-f $BackupDir]; ThenMkdir-p $BackupDirFiIf [-F ${backupdir}/$Cur _bak_name_gz]; ThenRM ${backupdir}/$Cur _bak_name_gzFiCp-r ${sitedir}/${sitename}/${backupdir}/${cur_bak_name}/CD ${backupdir}TAR-CZVF ${cur_bak_name_gz

Nginx diary cutting script and MySQL regular backup script Most of the log cutting and backup mechanisms are the same: Below is the Nginx diary cutting script#! /Bin/bashLogpath = '/home/nginx/Log'Nglogs = '/opt/nginx/logsMkdir-p

install MySQL for you" wgetHttps//repo.mysql.com//mysql57-community-release-el7-10.noarch.rpm--no-check-certificate rpm-UVH mysql57-community-release-el7-Ten. noarch.rpmfi#安装系统Yum Installmysql-community-Server #启动服务 service mysqld start #查看临时密码文件grep 'Temporary password'/var/log/mysqld.log Rehat backup MySQL Script1. The code is as follows: #!/bin/Bash #保存备份个

Tags: backup div 2.0 ICA span configuration exit RECT/ETC #!/bin/bash./etc/Profile .~/. Bash_profile oracle_base="/opt/oracle11g"Export Oracle_base oracle_home="/opt/oracle11g/product/11.2.0"Export Oracle_home oracle_sid="ORCL"Export ORACLE_SID Export Nls_lang=American_america. ZHS16GBK Ld_library_path="$ORACLE _home/lib:/lib:/usr/lib:/usr/local/lib"Export Ld_library_path PATH="$ORACLE _home/bin:/sbin": $PATH export PATH schemas="Succezbi Sdgsbi"Oraba

Label:Little stuff, for database backup. Retained. #!/bin/SHkeepdays= -currenttime=`Date "+%y-%m-%d-%h-%m"' Backpath="/sql_bak/"DbName="Smdb" Echo${currenttime}/usr/bin/mysqldump--default-character-set utf8-u xxx--password=xxx--database ${dbname} >${backpath}${dbname}.${currenttime}.sql; /usr/bin/SCP${backpath}${dbname}.${currenttime}.sql [email protected]1.2.3.4: ${backpath}${dbname}.${currenttime}.sql; Find${backpath}-name"*.sql"-mtime +${keepdays}-

/ sendmail.sh[emailprotected] "Mysqldumperror" "$CONTENT" fiecho ' ******** **end********** ' >> $LOG _fileSenfmail.sh content:[Email protected] myfile]# cat/usr/local/zabbix/share/zabbix/alertscripts/sendmail.sh#!/bin/bash# $ sendmail address# $ sendmail subject# $ content[email protected]send_mail=/usr/local/zabbix/share/zabbix/alertscripts/ Sendemail-v1.56/sendemailserver_mail=mail.benguo.cn$send_mail-f $sender-T "$"-S $server _mail-u "$" m "$ $" >> /dev/nullSendMail:sendemail-v1.56.tar.gzAd

#!/bin/bash#theisscriptbackup/etcdirectory! #author:zhangjun (e-maill:[emailprotected]) date=$ (date+%y%m%d) size=$ (du NBSP;-SHNBSP;/ETC) if[-d/tmp/dbbak] thenecho "date: $date!" >/tmp/dbbak/dbinfo.txt echo "size: $size!" >>/tmp/dbbak/dbinfo.txt cd/tmp/dbbak tar-zcfetc_$date.tar.gz/etcdbinfo.txt >/dev/nullrm-rf/tmp/dbbak/dbinfo.txt Elsemkdir /tmp/dbbak echo "date: $date!" >/tmp/dbbak/dbinfo.txt echo "size: $size!" >>/tmp/dbbak/dbinfo.txt cd/tmp/dbbak tar-zcfetc_$date.tar.gz/etcdbinfo.txt >/dev/

In linux, the mysql automatic backup script code bitsCN.com is stored in/home/user/mysql_backup.sh. Crontab # Crontab-l # M h dom mon dow command 28 16 ***/home/user/mysql_backup.sh The script is as follows: #! /Bin/sh # Mysql_backup.sh: backup