robocopy backup script

Mysql4.0 is the backup script for the master database when the master database is started. mysql4.0 is an old version, but some enterprises that are used earlier are still using it. When creating a Master/Slave instance, especially when an online server creates a Master/Slave instance, ensuring data consistency is a big problem: for example, repeated Data Execution occurs when the slave database is created

Redis-dump Command installation environment refer to the link address:http://blog.51cto.com/wujianwei/2105124Redis Database backup script:[Email protected] ~]# cat/data/scripts/dump_redisdata.sh#!/bin/bashsource /etc/profile.d/rvm.sh/usr/local/rvm/bin/rvm --create ruby-2.3.4 >/dev/nullDATENOW=`date +%Y%m%d`DIR=/data/backup/redisdb/"$DATENOW"DATETIME=`date +%H%M`

Label::: Export data for specified service (ORCL) and password (PMIs) on remote machine (192.168.2.1) via exp command: The machine running the script must have Oracle @echo off @echo [data for backup PMIs system] Set hh=%time:~0,2% set HH=%HH: =0% set SID=127.0.0.1/ORCL set Backdir=d:\oracle_bak set Backfile=%backdir%\%date:~0,4%%date : ~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%:: @echo [Delete

#!/usr/bin/env python"This script is used for backup Directorys.Can backup a directory at a Time,and alsoYou can backup multiple Directorys at a time.‘‘‘Import TarfileImport OSImport Sys## The following lines is used to process the Directorys# to IS backed up#DIRS_SRC = Raw_input (' Enter directorys that which you want

Rem SVN version database backup script Echo off The REM subversion installation directory is set according to the actual svnclient installation directory. Set svn_home = "D: \ Program Files \ svnclient" The parent directory of all versions of REM is set according to the directory of the actual version library. Set svn_root = "E: \ svnroot \ repository" The Directory of the REM

The RMAN backup script in Windows is relatively simple. Let's look at the content. 1.ModifyRMANRelated Parameters RMAN> show all; RMAN> Configure controlfile autobackup on; RMAN> Configure controlfile autobackup format for device type disk to 'd:/backup/% F '; RMAN> exit; After setting the parameters as above, the control file and spfile will be automatically ba

MySQL Incremental backup script (innobackupex) 1. in the online environment, I sometimes write a simple script for Incremental backup of the MySQL database. 2. Add an automatic task and execute it every hour or shorter. #! /Bin/sh # Author RuM # Date 2015-07-10 BAKDIR =/tmp/mysqlbak BAKDIR_FULL = $ BAKDIR/full BAKDIR_A

Tags: Oracle automatic backupFirst, write the scriptvim/home/backup/oraclebk.sh#! /usr/bin #路径名, specify the path of the backup filepath=/home/backup/oracledata #根据指定日期格式, define the backup database file name filename= ' date + '%Y %m%d_%h%m "' #切换至指定路径 and create a folder CD $FILEPATH mkdir $FILENAME chmod 775 $FILE

/oracle/oradata/orcl/control02.ctl--Create a backup directorySql> Ho Mkdir/u01/app/oracle/coolbak--using the connector to generate the copy File commandsql> Select ' Ho cp ' | |name | | '/u01/app/oracle/coolbak ' from V$controlfile;' HOCP ' | | name| | ' /u01/app/oracle/coolbak '----------------------------------------------------------------------------------Ho Cp/u01/app/oracle/oradata/orcl/control01.ctl/u01/app/oracle/coolbakHo Cp/u01/app/oracle/or

DescriptionMySQL Database installation directory: C:\Program files\mysql\mysql Server 5.0MySQL Database storage directory: C:\Program files\mysql\mysql Server 5.0\dataMySQL Database backup directory: D:\MySQLdata_BakTo achieve the purpose: backup the MySQL database in the directory to the D:\MySQLdata_Bak directory, stored by date,And keep only the last 7 days of dataFor example:D:\MySQLdata_Bak\mysql\20120

Oracle full database backup script connect target backup username/password @ KFDB2; www.2cto.com connect rcvcat rman/rman @ rman; RUN {allocate channel ch00 TYPE 'sbt _ TAPE '; allocate channel ch01 TYPE 'sbt _ TAPE '; allocate channel ch02 TYPE 'sbt _ TAPE'; allocate channel ch03 TYPE 'sbt _ TAPE '; send 'ns_env = (ns_server = jcyz01, ns_client = nmkfdb2, ns_dat

Mysql database backup script #! /Bin/bash DBName = myqlDBUser = rootDBPasswd = 123456BackupPath =/root/LogFile =/root/db. logDBPath =/var/lib/mysql/ NewFile = "$ BackupPath" db $ (date + % Y % m % d). tgzDumpFile = "$ BackupPath" db (date + % Y % m % d)OldFile = "$ BackupPath" db (date + % Y % m % d -- date = '5 days ago '). tgz Echo "-----------------------------------------"> $ LogFileEcho $ (date + "% y-

ziparchivezip_command= "zip-qr '%s ' %s" % (target, ' '. Join (source) #runthebackupifos.system (Zip_command) ==0: print ' successfulbackupto ',targetelse:print ' Backupfailed '[[email protected] ~]# python backup.py Enter a comment--weichenrongsuccessful backup to/mnt/e/backup/20161201/1113 19_weichenrong.zip[[email protected] ~]# python backup.py Enter a comment-successful

#! /Bin/bash # Backup ad dbserver svr122.16to svr12234 # Sip = 192.168.4.154 CD/usr/local/yicha/tools/cnshop/backup /; Synchronize shell scripts. Original Author mr. Jin========================================================== ========================================================== === Tables_list = 'table. list' Tb_list = 'cat $ tables_list | grep-V "#"' Echo 'date + % F' % t' dB cntrade

Tags: admin password mysql#!/bin/bashBACKUPPATH=/DATA/BACKUP/TESTBK #备份路径mysql_bk_dir= $BackupPath/mysql_bk_dirlogfile= $BackupPath/backuplogPasswd=admin #mysql密码####################################### define MySQL Variables######################################newfile= "$Mysql _bk_dir"/test$ (date +%y%m%d). tar.gzdumpfile= "$Mysql _bk_dir"/test$ (date +%y%m%d). sqloldfile= "$Mysql _bk_dir"/test$ (date +%y%m%d--date= ' 5 days ago '). tar.gz###########

Tags: rman scripting shell1, the database is fully prepared to the hard disk[[Emailprotected]scripts]$catrman_backup.shsource/home/oracle/.bash_ profilermantarget/log=/home/oracle/backup/backupall_rman.log2. Incremental backup ScriptLevel 0 increments[[Emailprotected]scripts]$catrman_backup_level0.shsource/home/oracle /.bash_profilermantarget/log=/home/oracle/backup