rsync compressed backup

/mysqlbackup/dbname ' Date +%y-%m-%d_%h%m%s '. sql.gzCd/var/lib/mysqlbackupRm-rf ' Find. -name ' *.sql.gz '-mtime 5 ' #删除5天前的备份文件--------------------------------------------------------------------------------Step Three: change backup script permissionsCode:--------------------------------------------------------------------------------chmod +x dbbackup.sh--------------------------------------------------------------------------------Fourth step: Exec

File = Etc/testuser.pas This is the path where the password files are located, which will be described in detail laterThe hosts allow = 192.168.1.56 allows access to the IP address of this server, my client is 192.168.1.56 I'm going to fill this out, modify it as neededHosts deny = 0.0.0.0/0 this thing prevents access to the address. Okay, finish this. A very important configuration, is the password file, in Figure two, we must not pay attention to a folder, that is, etc folder, good, is

Description of related parameters in the mysql_back.sh script. The-c in the CT-c is the meaning of the command, that is, the-c is followed by the relevant commands, but these commands must Description of related parameters in the mysql_back.sh script. The-c in the CT-c is the meaning of the command, that is, the-c is followed by the relevant commands, but these commands must I. Environment Description (using rsync for mysql Incremental

Remote Automatic Backup rsync + ssh + sshpass: the advantages of mutual automatic backup between remote servers (www.2cto.com rsync) The vast majority of O M personnel know that, simply put, only the files that have been modified are backed up, reduce data transmission volume. At the same time, it can transmit data th

Cross-server/client BACKUP command: rsync usage Recently, we often need to deploy environments on a new server. Many things can be backed up directly from other servers without re-downloading and installing them. The rsync command is used: First, download rsync and install it on the "source server". take part in Bai

Although SQL server2005 has become a mainstream trend in the SQL Server family, SQL server2005 has developed functions such as automatic compression and backup, but still writes the compressed backup that you have written on the SQL2000 server, which will be used as a souvenir. 1. BackupUse masterDeclare @ path varchar (200) set @ Path = 'd: \

Inotify + rsync implements real-time file backup 1. inotify inotify is a powerful fine-grained and asynchronous file system event monitoring mechanism. The Linux kernel has been added to Inotify since 2.6.13, inotify can be used to monitor various events in the file system, such as adding, deleting, modifying, and moving. However, inotify only provides the C language interface, which is inconvenient to call

reads as follows: The code is as follows #!/bin/shRsync=/usr/local/bin/rsyncSsh=/usr/bin/sshKey=/home/localuser/.ssh/id_rsaRuser=remoteuserRhost=remotehostRpath=/remote/dirLpath=/this/dir$RSYNC-az-delte-e "$SSH-i $KEY" $RUSER @ $RHOST: $RPATH $LPATH The-a option is equivalent to option-rlptgod. In simple terms, this option can be recursive to synchronize almost everything in the past, very useful. Note that-A d

details, let us know the process of synchronization-L Keep Soft links-L with this option, the source files are synchronized when the soft link is synchronized-P Keep File permissions property-O Keep File owner-G hold File group-D Keep Device file information-T keep file Time properties--delte Delete files in dest that are not in SRC--exclude filter the specified file, such as--exclude "logs" will be the file name contains logs files or directories filtered out, not synchronized-P shows the sync

backup.sh, which reads as follows: The code is as follows Copy Code #!/bin/shRsync=/usr/local/bin/rsyncSsh=/usr/bin/sshKey=/home/localuser/.ssh/id_rsaRuser=remoteuserRhost=remotehostRpath=/remote/dirLpath=/this/dir$RSYNC-az-delte-e "$SSH-i $KEY" $RUSER @ $RHOST: $RPATH $LPATH The-a option is equivalent to option-rlptgod. In simple terms, this option can be recursive to synchronize almost everything in the past,

RsyncRsync not only transmits fast, but also in the transmission, can compare to copy the content and the local side data difference, if has the difference,Only the differential data is backed up, and if there is no difference, you do not need to back upTwo ways to work:1. Run on this machine, as with the CP command; for example: rsync-av/etc/tmp2. Run between two hosts via SSH, for example: rsync-av-e ssh

Tags: represents classic pat HTML remote host FST verbose targe fstabThere are many data backup tools under Linux, the most used is Rsyns (remote synchronization)Synchronizing Remote data like SCPSynchronizing Local data like CP[Email protected]:~# rsync/etc/passwd/tmp/1.txtCopy the/etc/passwd file to/tmp and rename it to 1.txtIf you are unfamiliar with rsync, yo

Rsync: Remote synchronization, you can synchronize data locally, will not overwrite the previous data, but the first to determine the existing data and the difference between the new data, only the data will not be the same part of the overlay.# yum Install Rsync.x86_64-yLocal synchronization[Email protected] ~]# rsync-av/etc/passwd/tmp/passwordsending incremental file listpasswdsent 959 bytes received B Yt

Two Rhel5.6web servers, which ran Apache, the directory is/va/www/html, now want to put online web data in real-time backup to another Web server, that is, this "another Web server" as a real-time standby machine, Here I refer to the Web machine on the line as the source server, as a real-time standby server called the target serverExperimental process:Part I: Configuring the target server:#service iptables Stop#setenforce 0#yum Install httpd#service

The MSSQL compression database tutorial Check backup set Repair Database SQL statement This tutorial provides an example of an SQL statement that examines the backup set repair database for the MSSQL server compressed database, and how the instance describes it.3, compressed database DBCC SHRINKDATABASE (dbname)

: Incremental backup, only the modified content is transferred Can be decompressed in real-time during transmission, reducing bandwidth consumption Can keep the original file permissions, events, soft and hard links Native replication supported, remote replication supported 3. Command parameters:-A represents archive mode, which backs up all content in the directory (including content in subdirectories), and maintains soft li

Learn about Robin's blog post, the original address below is his summary automation management is becoming more and more common,hyper-v virtual machines also can. Premise: system server2008 above,powershell3.0, import Hyper-V Library 1. Virtual Machine Automatic backup set-executionpolicy unrestricted #信任脚本Import-moduled:\hyperv\hyperv\hyperv.psd1# Every execution to the import library $BackupDriver = "E:" #备份驱动盘符 $BackupFolder =$ (get-date-uform

Project needs to obtain the real-time progress of rsync backup, mainly using the Subprocess module of the pipeline function, online check is someone wrote this: Popen = subprocess. Popen ([' Ping ', ' www.baidu.com ', '-N ', ' 3 '], stdout = subprocess. PIPE) while True:print Popen.stdout.readline () to Subproces The project needs to obtain the real-time progress of the

If the server disables password logon, you must use KEY,RSYNC-E "Ssh-i key" to resolve it, but the password requires non-interactive input (manual input), and scheduled task execution cannot be manually guarded.Combining expect can realize automatic input password Instance Code The code is as follows Copy Code #!/usr/bin/expectSet Timeout 30Spawn Rsync-avz--delete--exclude-from

Test environment: Windows Azure Shanghai Room, virtual machine configured for large (quad core, 7 GB memory), the disk situation is shown in the figure below. The database backup compression file is greater than 12.0 GB (12,914,327,552 bytes), placed in temporary Storage (D:). The database restore operation commands are as follows: RESTORE DATABASE [Cnblogstext] from DISK = N ' D:\cnblogstext.bak ' with FILE = 1, Move N ' Cnblogstext ' to n '