rman backup script for linux

This article refers to the concise python after modifying#!/usr/bin/pythonimporttimeimportos#1.thefilesanddirectoriesto bebackeduparespecifiedinalist.source=['/root ', '/tmp ']#ifyouareusingwindows,usesource=[r ' c \ Documents ', r ' D:\Work ']orsomethinglikethat#2.thebackup mustbestoredinamainbackupdirectorytarget_dir= '/mnt/e/ backup/' #Remembertochangethistowhatyouwillbe Using#3.thefilesarebackedupintoazipfile.#4. thecurrentdayisthenameofthesubdir

: target=today+os.sep+now+‘_’+\ comment.replace(‘‘,‘_’)+‘.zip’ #Noticethebackslash! #Createthesubdirectoryifitisn’talreadythere ifnotos.path.exists(today): os.mkdir(today)#makedirectory print‘Successfullycreateddirectory’,today #5.Weusethezipcommand(inUnix/Linux)toputthefilesinaziparchive zip_command="zip-qr‘%s’%s"%(target,‘‘.join(source)) #Runthebackup ifos.system(zip_command)==0: print‘Successfulbackupto’,target

Mysql data backup script bitsCN.com Mysql data backup script [html] # crontab-e #0 2 ***/home/mysql/bak. sh thisday = 'date "+ % G % m % d" 'bakdir = '/home/mysql/bak 'bak_name = $ bakdir/'Exp _' $ thisday '. SQL 'mysqldump -- default-character-set = utf8-h 192.168.1.10-u userName-p dbname-ppassword> $ bak_name for fn

= Time.strftime ('%h%m%s ')# Take a comment from the user to create the name of the tar fileComment = raw_input (' Enter a Comment: ')If len (comment) = = 0:target = Target_dir + today + os.sep + Now + '. tar.gz 'Elsetarget = Target_dir + today + os.sep + comment.replace ("', '-') + ' _ ' + Now + '. tar.gz '# Create The subdirectory if it isn ' t already thereIf not os.path.exists (target_dir+today):Os.mkdir (Target_dir+today)print ' Successfully created directory ', today# 5, We use the tar co

MySQL backup and crontab regular backup in Linux 1. back up a database ######################################## ########################### Back up a database ########## ######################################## ################# root user, create the backup directory mkdir-p/usr/local/cncounter/mysql_dumpcd/usr/local/

Quick Guide to Linux backup and recovery Level: Entry Chris Walden (cmwalden-at-us.ibm.com)E-commerce architect, IBM developer relationsJanuary 2004 IBM e-commerce architect Chris Walden willDeveloperWorksThe nine articles published in this article will guide you how to use your Windows Operating Skills in Linux. This section describes the content

#!/bin/bashmyuser=rootmypass=passwordsocket= "/var/lib/mysql/mysql.sock" mycmd= "mysql-u $MYUSER-p$MYPASS" MYDUMP= " Mysqldump-u $MYUSER-p$mypass "backup_dir="/work/backup/mysql "for Database in ' $MYCMD-e" show databases; "|Sed ' 1,2d ' |egrep-v "Mysql|schema" ' Do if [!-f $BACKUP _dir/${database}]; Then mkdir-p $BACKUP _dir/${database} fi $MYDUMP ${database} |g

The loss of important data can mean fatal damage. Still, countless professionals are ignoring the backup of their data. Although the reasons may vary, one of the most common explanations is that performing routine backups is really cumbersome. Because machines are adept at accomplishing common and repetitive tasks, automating the backup process is key to reducing the intrinsic tedium of work and the propens

It features multiple platforms. a script can back up multiple databases and package and upload them to ftp for backup. Mysqldump and tar are called for database dump and packaging. For detailed parameter descriptions, see source files. The code is as follows: #! /Usr/bin/pythonImport OSImport timeImport ftplibImport traceback# Config varsSystempathchr = "/" # path delimiter, * nix "/" win32 "\\"Dbuser = "

Set the script for regular execution in Linux, and run the script in linux. The following section describes the differences between ubuntu and non-ubuntu environments. In Linux, you often need to regularly execute some scripts to implement some functions. In

-datetime= "$START _backupbinlog_time" $LOG _dir/mysql-bin. [0-9]*|gzip>> $BACKUPDIR/db_daily_$date.sql.gzincrease_health= ' echo$ ' if[[ $INCREASE _health==0]];then echo "at ' $ (date+"%y-%m-%d%h:%m:%s ") ', mysql dbincresedbackupsuccessfully! " elseecho "MYSQLNBSP;DBNBSP;INCResedbackupfailed! " fi}functionbakup_cleaner () {iftest-d$ backupdir_older;thenecho "$BACKUPDIR _olderis Exist "#return0else echo "$BACKUPDIR _olderisnotexist,now Createit "mkdir-pv $BACKUPDIR _older# return1fi find $BACK

$backindexdir ]| | mkdir-p/data/indexback/indexfile= ' grep ' ^log_bin ' /etc/my.cnf|awk-f "=" ' {print$2} '. indexindexdir= ' grep ' DataDir ' /etc/my.cnf|cut-d=-f2 ' binfiles= ' Cat${indexdir}/${indexfile} ' Totalfile= ' wc-l${indexdir}/${indexfile}|awk ' {print$1} ' numindex=0for filein $binfiles;d onumindex=$ (($numindex + 1)) base= ' basename $file ' #判断备份目录里面没有这个文件, And is not a newly generated binary file (the above command will automatically create a new temporary no data) if[!-e $back

#!/bin/bash#auto backup MySQL#xiaosu 2015-08-06User=rootpassword=123456dir_back=/data/' Date +%y%m%d 'Date= ' Date +%y%m%d 'Database=test#判断用户是否是管理员rootIf [$UID-ne 0];thenEcho-e "\033[32mthe script must use root\033[0m"Sleep 2ExitFi#判断备份目录是否存在if [!-D $DIR _back];thenMkdir-p $DIR _back;ElseEcho-e "\033[32mthe $DIR _back is exist\033[32m"Fi#备份数据库/usr/local/mysql/bin/mysqldump-u$user-p$password-d $DATABASE > $

The program needs to overwrite the backup file because of the project. (The original solution is to use VB6 to traverse the file, do not spit slot) Requirement 1: Check the modification time of each file, if it is less than the date parameter, then backup (and delete); Requirement 2: Keep the directory structure of the backed up files. Backing up files under Linux