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
1. Install Mutt mail Client
# yum Install Mutt-y
2. Create a script
# vi/etc/rc.d/mail_to_bak_daily.sh
Version One:
#!/bin/bash # ========================================================= # Please enter which separate directory you want to put the backup data in basedir=/backup/ Daily # ============================================
A few days ago have friends to help write a MySQL data backup script, so there is the following through the mysqldump command backup database script, paste out to communicate with you, if there is a problem, please correct me, thank you.Implementation features:1 backing up the specified database2 Delete the
Share your own linux backup script (webdata + mysql) the function is used with crontab to automatically back up the website directory and mysql local copy ftp copy mailbox copy local and ftp automatically delete 3 days ago linux requires sendmail and ftp if not available set your own information when installing and using yum.#! /Bin/bash www.2cto.com # function: automatic
Tags: Execution time thinking error etc script rom mkdir grepShare a MySQL sub-library backup script (original) Development ideas: 1. Path: Specify the location of the backup, the path (the first to determine whether there is no creation of a directory) first defined, my path:/mysql/
Backup is the most important. Many test environments are built on windows, and there is one on the master's computer. to ensure its security, it is decided to perform regular backup. The example shows how to use scripts + windows scheduled tasks in windows to periodically execute full backup. Backup
1. File backup scriptFunction: Use this script to backup files, directories in the system, the backed up files are compressed in gzip, and date to mark the date of backup, the name of the backup file or directory is written down to the log file for viewing.The
The following operations are performed by Sybase users:
Create a script file, such as/Sybase/script/dump. Sh.The category is as follows:$ Cat dump. Sh/Sybase/OCS-12_5/bin/iSQL-USA-P ********-s ******-I/Sybase/script/dump. SQL-O/sybse/script/dump. logMV/caiwubackup/backup/cwb
Enterprise Manager--Management--sql Server Agent--Right-click Job--New job--Enter the job name in the "General" entry--"Step" item--New--Enter the step name in step name--SELECT "Transact-SQL script (TSQL)" in "type"--"Database" Select the database that executes the command--Enter the statement to execute in the command:-Determine--"Dispatch" item--New schedule--Enter the schedule name in "name"--Select your job execution schedule in the schedule type
Tags: database mysql article backupThis article focuses on how to use the shell to achieve full MySQL, incremental backup. Incremental backups replicate mysql-bin.00000* to the specified directory in Monday-Saturday 3 o'clock in the morning, while full-scale backups use mysqldump to export all databases, every Sunday 3 o'clock in the morning, and delete the mysq-bin.00000* left last week. The backup operati
UbuntuServer MySql database backup script code: UbuntuServerUbuntu
Ming:
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 backup was executed ), at last, only the backups of the last 7 days are retained.
Steps:1. create a directory to s
Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble, but because the use of less people, do not know how to deal with the matter, I wrote a simple implementation of the basic function of w
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 backup was executed ), at last, only the backups of the last 7 days are retained. Implementation steps: 1. Create a directory for saving the backup file:/home/mysql_datacd/home
Note:
Here I want to back up the pw85 database under
UbuntuServer MySql database backup script code: UbuntuServerUbuntu
BitsCN.com
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 backup was executed ), at last, only the backups of the last 7 days are retained.Steps:1. create a direct
In linux, the mysql automatic backup script code bitsCN.com is stored in/home/user/mysql_backup.sh.
Crontab
# Crontab-l
# M h dom mon dow command
28 16 ***/home/user/mysql_backup.sh
The script is as follows:
#! /Bin/sh
# Mysql_backup.sh: backup mysql databases and keep newest 5 days
Label:MySQL 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. I wrote the previous article about Xtrabackup's hot spare tools, see http://www.linuxidc.com/Linux/2015-02/113058.htm. The following script is the ability to automatically back up a database based on the Xtrabackup implementation. Requirem
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 backup script here to implement automatic backup with ease, in addition, the files backed up in N days can be retained. This script is divided into two files, one is the e
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.