robocopy backup script

Tags: mtime date mysq mysqldump generate successful%s backup MySQL BakRequirements: Back up the MySQL database and upload the data backed up files to the FTP serverFTP Server IP Address: 192.168.6.9FTP Server account/password: test/test123 1. Root user creates backup script path: $ mkdir /opt/databak $ cd /opt/databak 2. Create a

Share a self-written mysql automatic backup script, timed execution settings, and windows automatic FTP. Please advise. Prerequisites: vsftpd is enabled for the mysql database server and an appropriate account is configured for the Intranet storage server. Share a self-written mysql automatic backup script, timed exec

========================================================== ==========This article isHeyuanhuiOriginal Make sure that the original author information and original links of this article are complete and retained! NN: khlerE-mail:Khler@163.comQQ: 23381103MSN:Pragmac@hotmail.com========================================================== ========== Recently, a service named TWS is implemented in Linux. It outputs logs using Syslog and uses MySQL as the background database. I encountered two problems

Tags: xtrabackup mysql incrMySQL backup script, record:Fully prepared:#!/bin/sh set-x user=root password=123456 time= ' date+ "% Y-%m-%d-%h-%m "' date>>/data/mysqlbackup/logs/$time ' _allbackup.log ' #1 beginFullBackups echo "Beginbackup--------------------------------" >>/data/mysqlbackup/logs/$time ' _allbackup.log ' /usr/bin/innobackupex- -defaults-file=/etc/my.cnf--user= $USER --password= $PASSW

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************Rman Backup Script#! /bin/bashSu-oracle Rman Target/Backup as compressed BACKUPSET DatabaseInclude current controlfile format '/orabak/db_%d_%t_%s 'plus arc

statement in the exported file to specify the Binlog location of the current backup, which can be done if you want to restore the file to slave. 1.2 RestoreThe file backed up with Mysqldump is a SQL script that can be poured directly into it, and there are two ways to import the data.Directly with the MySQL clientFor example:/usr/local/mysql/bin/mysql-uyejr-pyejr Db_name Use SOURCE syntax (experiment not s

Tags: io ar os for file data on log BS@echo offSetlocal enabledelayedexpansionTitle%date%%time:~,8% by Liaoning Sunray Software Technology :: XXX Database backup:: Define Database SIDSet SID=ORCL :: Define user an array groups (spaces separated by each user for example: User1 user2 User3)Set USERARR=AAASet PSWDARR=BBB :: Specify the number of days to deleteSet daysago=3 :: Specify the backup pathSet Filepat

Today, the company asked me to copy the backup files on the server to the internal server, and as long as they are up-to-date, well, what is the ideal goal of O M personnel, that is, what can be done by computers, never do it by yourself.System: centos 5.9Environment: The backup file is under/root/bak. Of course, I tested it on a virtual machine.1. Backup file e

@echo offecho Online Redemption system automatic backup script (do not close) Contact: Tel:: Loopset/a "fdate=%date:~,4%%date:~5,2%%date:~8,2%"-5If%time:~0,8%==17:06:00 (If exist "D:\mysql_db_backup\lottery_online_ticket_%FDate%.sql" (del/q/A "D:\mysql_db_backup\lottery_online_ticket _%fdate%.sql ")C \ "program Files (x86)" \ "Mysql\mysql Server 5.5" \bin\mysqldump.exe--opt-u root--password=admin lottery_on

@echo offREM *********************mysql backup Script ***********************REM ***1, backup MySQL, generate jyz-2015-03-09_14.sql format File * * * *REM * * * The file name: Date _ When. DMP, customizable format * * * *REM * * * ensures that the number of DMP files in this directory is specified (i.e., deleted, retained for the last 10 days) * *REM ************

I failed to copy a backup script like laruence, and nobody was here-Linux general technology-Linux technology and application information. Here is the details. Z is a newbie, the level is shit, Mo Xiao: 0w223dc ...... To make an automatic backup can only be like this Bird brother: # (Bird brother backs up/var/lib/mysql to/disk2/

As the company's website increases and the occupied space increases, write a script. Under Incremental Backup#! /Bin. bash# Backup 00:00:00Week = 'date + % U'Date = 'date + % Y-% m-% d'Year = 'date + % y'Month = 'date + % m'Day = 'date + % d'Bakpath =/var/bak/webbakWebpath =/var/htmlwwwWzbakup =/var/bak/webbak/wzbfBackup = $ bakpath/$ year/$ month/$ (date + % d-d

The library to be backed up, passed in as an argument, delete the backup file from the previous 30 daysThe backup directory is created if it does not exist,/back/mysql/#!/bin/bashDatabase=$1Username= "Root"Passwd= "Redhat"Backupdir= "/backup/mysql"Curdate= ' Date +%f 'Log= "/var/log/mysqlbackup.log"[$?-eq 1] | | {echo "Usage: $ DATE"Exit 99}[-D $BACKUPDIR] | | Mk

= 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

) fortinthread_list: t.start () t.join () if__name__== "__main__ ": main () 3. The backup SCP generated on the same day to another place #!/usr/bin/envpython #_ *_coding:utf-8_*_ "" @File: backup_db.py @Author: oldtan @Email: [ Emailprotected] @Last modified:20180408 "" "Importos importdatetime from Threadingimportthread remote_path= '/mnt/tantianran_mysql_backup/' REMOTE_HOST= ' 10.36.1.55 ' remote_user= ' root ' path= '/mnt/tantianran_mysql_backu

agoFind $ basepath-mtime + 7-name "*. SQL .tar.gz"-exec rm-rf {}\;Done # Delete the generated SQL fileRm-rf $ basepath/*. SQLTo support remote server backup, you can change the mysqldump parameter in row 17th to-p123456 followed by-h 192.168.1.123 remote ip.After the shell script is written, it is saved in the specified location, for example, in/home/backup_mysql/back_mysql.sh. Now we start to ru

#!/bin/bashcd= ' df-l |awk ' nr==3 {print $4} ' |awk ' BEGIN {fieldwidths= ' 2 1 "} ' {print '} 'If [$CD-ge 20];thenecho " hard disk space is full and cannot be backed up " | Mutt-s " backup alarm, please replace the hard drive in time " [Email protected] exit 1FiLogrotate-f/etc/logrotate.confTar zcf/opt/backup/' Date +%y%m%d%h%m '. tat.gz/var/log/messages.* >/dev/nullRt= ' echo $? 'If [$RT-eq 0];thenecho "

#!/bin/sh# back Tomcat Catalina. outCD/home/Log_bak #the filedate= ' Date'+%y%m%d-%h%m'' ARCHIVE=$DATE. Tar.gzfile="Tomcat_""$DATE. Catalina.out"#开始备份之前, write the backup information header to the journal file Echo" ">>Log.txtecho" ">>Log.txtecho"——————————————— –">>Log.txtecho"BACKUP DATE:"$ (date +"%y-%m-%d%h:%m:%s") >>Log.txtecho"——————————————— –">>log.txtcp/tomcat/logs/catalina. out/home/log_bak/$files

DECLARE @name varchar DECLARE @disk varchar (DECLARE) @temp varchar set @temp =replace (replace ( Replace (Convert (varchar (+), GETDATE (), +), ': ', ') ', ' ', '), '-', '), '. ', ') set @name =n ' DEMO ' [email protected]+ '-full Database backup ' Set @disk =n ' F:\backup\[full]demo ' [email protected]+ '. Bak ' backup database [Cmdi] to disk = @disk with Nofo

#!/bin/bash# every morning at 4, MySQL backs up data #chmod theBackup.SH#crontab-e#0 4* * * */home/erya/run/moniter/mysql_backup.SHUser="radius"Password=""Host="localhost"db_name="radius"#backup Directory Base_dir="/home/backup"Backup_log="${base_dir}/mysql_backup.log"Backup_path=${base_dir}#file InfoDate=$(Date+"%y-%m-%d") filename= $backup _path/$db _name-$Dat