robocopy backup script

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

; $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

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

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

MySQL backup script and mysql script. MySQL backup script, mysql script mysqlbackup. php :? Php backup mysqlset_time_limit (0); date_default_timezone_set (PRC); configuration $ configsa

= $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

MySQL backup script, MySQL script mysqlbackup.php: Php//backup MySQL Set_time_limit(0); Date_default_timezone_set (' PRC '); //Configuration $configs=Array( ' Host1 ' =Array( ' localhost ', ' root ', ' root ',Array(),//back up all databases as empty, or back up those databases' D:/xampp/m

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.

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