DBAs are mainly responsible for database backup and recovery. It is important to back up the database effectively and restore the database in time when the database crashes, if you back up the database manually on Linux, it will cause a lot of trouble. I wrote a script to add the script to the regular task list and regularly perform data
Transferred fromOracle Database Automatic Export backup script (in Windows) Because WinRAR charges fees, I modified the script to use 7zip for compression.
@ EchoOff
@ Echo ===================================================== ============================================
@ Echo the Oracle database's Automatic Export
The logs backed up by RMAN are put in a file. The backup script in nocatalg was sent using Linux Sendmail. However, this affects the system startup time. It is still sent using python. After the backup, call the script. Send RMAN logs to the mailbox. Check the email in the morning to check whether the
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
Label:Add the following script to the server scheduled task, set to execute daily, the file backup path is the path of the script, you must install the compressed file@echo offREM Calculates a date that precedes a specified number of days and is used to delete data for a specified number of daysSet daysago=7set/a year=1REM assumes that the format of the system da
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
Note:
Here I want to store the MySql database directory/Var/lib/mysqlThe followingPw85Back up the database/Home/mysql_dataAnd saveMysqldata_bak_2012_04_11.tar.gzCompressed file format (2012_04_11 indicates the date on which the backup was executed.).7Daily backup.Steps:1. Create a directory to save the backup file:/home/mysql_dataCd/home # enter the DirectoryMkdir mysql_data # create a directory2. Create a
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
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
This backup script is organized from the network, and some comments are added. This script is clear and can be applied to the production machine with slight changes.
1 #! /Bin/ Bash 2 ######################################## ############################### 3 # 4 # Backup policy: 5 # Grade 0 backups every
Nonsense not to say more, directly to everyone to paste the code, the specific code as follows:
#!/bin/sh #****************************************************************** # File:oraclebak.sh # Creation Date: 2014/1/22 17:57:32 # Last MODIFIED:2014/1/22 17:57:34 # scripting Features: Oracle Backup Scripts # Execution method: 1. The first execution requires the root user to execute, and the script w
Tags: identified database backup databases server specific stepsMySQL is widely used in small and midsize businesses, and the following script can be used for full backups in a production environment.Backup scenario: Full backup every 1:30 A.M., with 30 days of backup data (binary logs can be opened for incremental
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.