rsync backup script

MySQL backup script1. The simplest#!/bin/bashd= ' Date +%w '/usr/bin/mysqldump-umylinux-pxxxxx mylinux >/data/mysqlbak/$d. sql2. A slightly more complex#! /bin/bashStore_name= ' Date +%m%d 'store_name2= ' Date +%w 'Store_dir= '/backup/mysqlbak 'Remote_dir= ' Ypl-web:/backup 'Backup_dir= '/data/mysql/'EXEC 1>/var/log/mysqlbak.log 2>1echo mysqlbak start ' Date '/et

I wrote a MySQL backup script in Linux. This is the first version. Only one database can be backed up. Every night at, I run the script with a timer and it will be automatically backed up. In the future, multiple databases can be backed up. If the backup fails, text messages will be sent to the mobile phone and expired

the Oneinstack one-key package to take a backup script locally, remotely, and regularly back up Web site files/databases in a test machine environment. First, oneinstack Backup preparation work The method shared by Chiang in this article is based on the Oneinstack scripting environment, so if other web environments are not available, we can use the

'==================== Lan File Automatic Backup vbs script ============================ ' 'Condition: 10.97.1.x xcopy/xcopy belongs to Adminstrator. 'The directory where the shared backup file is located gives xcopy users full control! 'After running, there are two processes in the management process: wscript. EXE , Ping.exe 'Use the date as the log file name

Tags: exec http HTML mode. SQL SQL OCA Password BlogTransferred from: https://www.cnblogs.com/leffss/p/7832047.html#!/bin/bash# fully-prepared, generally on-board execution, for small-medium MySQL database # Delete 15 days ago Backup #fafu_li# time: 2015.08.10source/etc/profile #加载系统环境变量source ~/. Bash_profile #加载用户环境变量set-o nounset #引用未初始化变量时退出 #set-o errexit #执行shell命令遇到错误时退出user = "root" pas Sword= "123456" host= "localhost" port= "3306" #需备份的数据库,

With RMAN automatic backup script, and automatic copy of the backup file to other machines last write a batch backup script with exp, the response is good, see: http://www.cnoug.org/viewthread.php? Tid = 20864 Encouraged by this, the RMAN

I. Incremental backup scriptLevel 0 backup script: The red part is the directory of the custom backup fileCopy codeThe Code is as follows:# Script.: BackupFull. sh# Creater: xyh# Date: 2014-03-08# Desc: backup full database datafi

Tags: script mysql incremental backup automatic pythonMySQL database is commonly used by the mysqldump export SQL for backup, but not suitable for a large number of databases, speed, lock table is two serious problems. The front has written a blog about Xtrabackup hot spare tools. The following script is the ability to

Here I want to back up the pw85 database under the MySql database storage directory varlibmysql to homemysql_data and save it as mysqldata_bak_2012_04_1 Here, I want to back up the pw85 database under the/var/lib/MySql database directory to/home/mysql_data and save it as mysqldata_bak_2012_04_1. Note: Here I want to back up the pw85 database under the/var/lib/MySql database directory to the compressed file format of/home/snapshot (2012_04_11 refers to the date on which the

RMAN backup is easy to use for Oracle database backup and recovery, with low costs. For non-catalog mode, it is undoubtedly the first choice to embed the RMAN script into the shell script and then use crontab to back up small and medium databases. This document provides an easy-to-use RMAN

We often need to back up some data in our online maintenance work. Although the work is not complicated, it takes a lot of time. I will share a Linux backup script here to implement automatic backup with ease and During our online maintenance work, we often need to back up some data. although it is not complicated, it takes a lot of time. I will share a Linux