rsync backup script

Mysql daily backup and incremental backup script bitsCN.com INTENDED AUDIENCE This article is tested in linux and mysql 4.1.14. after modification, it may be applicable to mysql 4.0, 5.0 and other versions. This article is applicable to mysql that does not enable replication. If replication is started, you may not need to adopt this

Preparations: lftp must be installed in VPS in advance. lftp is powerful. CentOS directly executes: yuminstalllftp and Debian execute: apt-getinstalllftp. You need to create the/home/backup/directory on VPS and the backup directory on FTP. If there are not many VPS databases, you can use Godaddy free space (10 GB space, 300 Preparations: Lftp needs to be installed in VPS in advance. lftp is powerful and can

Preparatory work: Need to advance in the VPS to install good lftp,lftp function more powerful, CentOS Direct execution: Yum install Lftp,debian execution: Apt-get install. You need to create the/home/backup/directory on the VPS and create the backup directory on FTP. If the VPS on the database is not much to use GoDaddy free space can (10GB space, 300GB traffic), as long as the registration of the domain

: bakwww.sh file must have the permission to execute!LINUX Automatic backup script filesFirst I set up a folder under the/root/backup directory,#mkdir/root/backup/mysqlbackupLater at five o'clock every day, there will be a file saved here.Then create a new file#vim/root/mysqlautobakInput:Filename= ' Date +%y%m%d 'mysql

Mysql backup policies can be divided into four types: 1) directly copy database files (not recommended) 2) use mysqlhotcopy to back up the database 3) Use mysqldump to back up the database 4) use the master-slave replication mechanism (for real-time database backup) Mysqldump is widely used and easy to operate. The following describes the mysqldump backup policy.

; $logfile - Bin_backup $ if [$?-eq 0];then the echo "$ (date +"%y-%m-%d%h:%m:%s ") [Note] MySQL binary log file backup is finished" >> $logfile the chmod-r $backup _binlog the Else the echo "$ (date +"%y-%m-%d%h:%m:%s ") [Warning] Mysql binary log file backup is not completed" | cat | tee-a $LOGFIL e | Mail-s "MySQL binary log

Mysql backup script and delete the backup file bitsCN.com from the previous five days USER = root # Database username PASSWORD = cucrzmysql # database user PASSWORD # DATABASE = idssr # DATABASE name For DATABASE in 'ls/mysql/data/mysql/| grep idss' # DATABASE name Do # WEBMASTER = 849699940@qq.com # administrator email address to send

Tags: blank database target MySQL periodichttp://hongge.blog.51cto.com/ Backups of MySQL databases in a production environment are recurring operations, so it is common to write script implementations that periodically execute backup scripts through Crond scheduled tasks mysqldump Backup scenarios: Sunday 1 o'clock in the morning full-Library

= $user _name--password= $password-- Slave-info--incremental--incremental-basedir= $bacKDIR/REC2 $backdir/rec3 1> $out _log 2>1echo "Completing the 3rd incremental backup"elif [!-d "$backdir/rec4"];thenecho "# # # #start 4 Incremental backup at $BEGINTIME to directory Rec4" >> $time _cost$backupbin/innobackupex--defaults-file= $file _cnf--no-timestamp--user= $user _name--password= $password-- Slave-info--in

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/

:%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

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