robocopy backup script

:%m:%S 'Echo "${time_now1} start to increment backup">>${log} CD/app/Mysql.binTarCF ${time_hour}_mysql_bin.Tar. GZ *wait MV/app/mysql.bin/*. tar.gz ${backup_dir} CD ls ${backup_dir}/${time_hour}_mysql_bin.tar.gz >/dev/null if [$?-eq 0];then t ime_now2= ' Date +%y%m%d-%h:%m:%s ' echo ' ${time_now2} increment backup successfull ' >> $LOG else Echo ' ${time_now2 } Increment

Use shell to write a mysql data backup script and shellmysql Data Backup Ideas It's actually very simple. Write a shell script and use mysqldump of mysql to export data to the corresponding SQL file. Use crontab of linux to regularly run the corresponding script and save the

First modify the script for necessary configuration, and then run it as the root user. 1. first, the first parameter is used for remote backup. 2. local parameter for local backup 3. parameter-free remote backup note: you need to add a user to the Mysql user on another host .. where you need to configure: # definehosta

(1) remote TELNET to back up data to the SHLL script of the tape drive Lgmfcm:/u01/Oracle/CIC/BACKUP] cat TAPE_BACKUP.sh:$ {OK = 0 }$ {FAIL = 1 }$ {CANCEL = 3}: $ {MM = 'date + % m '}: $ {DD = 'date + % d '}: $ {YY = 'date + % y '}: $ {DEVFILn = '/dev/rmt/0cn '}: $ {FLOG =/u01/oracle/CIC/LOG/TAPE_bk _ $ {MM }$ {DD}. log}: $ {FLST =/u01/oracle/CIC/LOG/TAPE_bk _ $ {MM }$ {DD}. lst}:$ {HOST = 'uname-n '}./U01/

MySQL backup script and mysql script Mysqlbackup. php: Mysqlbackup. bat: D: \ xampp \ php \ php.exe-q D: \ wamp \ www \ php_lib \ basic \ mysqlbackup. phpPause; Linux shell backup MySQL: #! /Bin/sh # sed-I's/^ M // G'/home/taskschd/backup. sh # Note: ^ The input method of

after the measurement product deploys the service end, because the service side has each kind of encapsulation encrypted attachment, the file and so on data, in order to safeguard the security of the information, in addition to establish the high availability backup mechanism, we can through the batch script, unifies to the system plan to carry on the local or the offsite

Today an accident, I wrote the diary of the big half month the encrypted file is damaged and cannot be recovered. He decided to write a dedicated backup script file. The main idea is to create a folder under current directory backup based on today's date, and then copy the files to that folder. The script files are as

Article Title: tiptop automatic backup script backup. sh. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source. # Create a crontab Scheduler Crontab-e 0 *** sh/u3/backup/tool/

#!/bin/shsource/home/oracle/.bash_profileif [-Z]then echo "please Input a number,usage:0|1|2" Exitelse Rman_leve L=$1fiexport oracle_sid=xxxxexport today= ' date ' +%y%m%d ' export rman_dir=/backup/archivelog/rman/$ORACLE _sid/$ today-$RMAN _levelmkdir-p $RMAN _dircd $RMAN _dirlogfile=ora_rman_bk_$oracle_sid-l$rman_level-' date ' +%y%m%d '. log# Rman backup Rman target/msglog= $RMAN _dir/$LogFile By the way

/Sysaux01.dbf/Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Undotbs01.dbf/Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Users01.dbf/Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Example01.dbf/Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Bxj_emp_data01.dbf/Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Bxj_emp_data02.dbf/Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Redo03.Log /Opt/Oracle/coolbakho CP/Opt/Oracle/Oradata/Gavinsit/Redo02.Log /Opt/Oracle/coolbakho

Mongolerman backup script and automatic deletion of duplicate backup files #!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo "Please Input a number,Usage: 0|1|2" exitelse RMAN_LEVEL=$1fiexport ORACLE_SID=xxxxexport TODAY=`date '+%Y%m%d'`export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$TODAY-$RMAN_L

Oracle Rman backup script and automatic deletion of duplicate backup files, mongolerman #!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo "Please Input a number,Usage: 0|1|2" exitelse RMAN_LEVEL=$1fiexport ORACLE_SID=xxxxexport TODAY=`date '+%Y%m%d'`export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$

This script implements the following functions: 1. Backing up mysql databases online; 2. Saving backup logs to log files; 3. compressing data backup files; 4. Remotely ftp the compressed file to the backup server; 5. deleting data that has been backed up locally for more than seven days is mainly to prevent the abnorma

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/access.log $logpath/$ (date +%y)/$ (date +%m)/acc

MySQL database Regular automatic backup script, mysql database scriptThe most important thing for a Web system is the security and integrity of the database.It is very important to back up data regularly. Do not be lazy on this issue. If your important data is lost, it will make you cry.Export table structure and data mysqldump-uroot-pmypassword -- databases fansunion -- result-file =/var/www/

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 #保存备份个数number=3#备份保存路径 Backup_dir=/root/mysqlbackup #日期DD=`Date+%y%m%d ' #备份工具 tool=mysqldump #用

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 $ logpath/$ (date + % Y)/$ (date + % m)Mv $ n

Join the Crontab timed task to perform daily. The effect is: Back up the database to the specified directory every day, delete the files backed up 10 days ago. Here's what the script reads: The code is as follows Copy Code #!/bin/bashMysql_host= "127.0.0.1"Mysql_user= "Root"Mysql_passwd= "********"Back_dir= "/www/backup/database/"ignore_db= "Information_schema|mysql|performance

/ 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

-----SQL ScriptsDECLARE @fileName varchar (255),--Define the backup file name variable@dbname varchar (255)--Define the backup database name variableDECLARE mycursor cursor Fast_forward for select name from master: sysdatabases ORDER BY name--Define a cursor objectOpen MyCursor--opening cursorsSet @dbname = ' PYSF 'Set @fileName = ' D:\bakck\1\ ' [email protected]+convert (varchar), GETDATE (), + '. Bak ')-