Today, there is no doubt about the importance of data protection for both individuals and businesses. Once the data has problems, such as lost, stolen, damaged, the consequences will be grim. For example, the site was attacked, the content was tampered with, but found no backup, unable to recover, which will affect the normal operation of the site, serious will lead to the closure of the site. So do a good job of data storage
1. First, create a backup directory and backup script file. this is not much to mention. 2. back up and submit the file as follows :#! /Bin/bashnow =$ (date + quot; % Y % m % d quot ;) # obtain the current date days = 5bk_dr =/# path to the backup directory find $ bk_dr/backup file name-mtime + $ days-execrm-rf {}\;
Execute SQL Server database backup and SQL database backup using Windows batch processing commands
Create mybackup. bat and enter the following content to directly run the script to start automatic database backup. You can also add the script to the windows Task Plan for execution.
@ Echo offset path = % path %; C: Program Files \ Microsoft SQL Server \ 80 \ Tool
Article Title: tiptop automatic backup script backup. sh. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
# Create a crontab Scheduler
Crontab-e
0 *** sh/u3/backup/tool/backup. sh #
The difference between DB2 online backup and offline backup
1 The general default to establish a DB2 database is not supported online backup (in the DB2 Control center)
If you want a DB2 database to support Online backup, update db CFG for sampledb using Logretain=on serexit=on,trackmode=on
2 If a DB2 database suppo
There are many backup methods for Oracle databases, including industry-recognized cold backups, hot backups, and so on, but regardless of which backup method is used, the purpose of the backup is to recover the system at the lowest possible time and cost in the event of a failure. Unfortunately, Oracle seems to have not done much layout in the cloud at the moment
SQL Regular automatic backup, encryption and compression of backup files, and automatic downloadRelease date:Author: knife tip customer QQ: 51978456 MSN: peters99@hotmail.com========================================================== ======= */
AsProgramStaff or database maintenance personnel may be frequent
The thing to do is to back up the database, and it is best to back up the database remotely for s
Backup and recovery data database Case 2-use online backup to restore the database.
1. Set archiving Parameters
1,
Drop database mydb
Create Database mydb
Update dB CFG for mydb using implements logpathd: \ backup \ log
2. updatedb CFG for using userexit on // Enable User exit
3. db2update dB CFG for using logretain on // enable archiving logs
4. db2update dB CFG
10. Click Finish11, we can see the corresponding task plan in the Mission Plan library.12, then we double-click the corresponding scheduled task, click "Edit Trigger", here we set the scheduled task time for each day, and then back every two days;13, then we export the backup configuration, and then delete the corresponding task schedule;14. We then create a new backup plan in Windows Server
#! Binsh # Name: mysqlFullBackup. sh # PS: MySQLDataBaseFullBackup. # Writeby: I. stone # LastModify: 2007-11-17 # Usemysqldump -- helpgetmoredetail. # define variables. Modify the variables as needed # define the script directory scriptsDir 'pwd' # define the database directory my
#! /Bin/sh # Name: mysqlFullBackup. sh # PS: MySQL DataBase Full Backup. # Write by: I. stone # Last Modify: 2007-11-17 # Use mysqldump -- help get more detail. # define va
Tags:. SQL sleep Roo mysq incremental build dump MySQL dataOnline MySQL backup of a small business Full-scale backup #!/bin/bash #crete by HEXM at .-Ten- Geneva#scripte name:full_backup.SH#descriptioni: MySQL full backup. Oneday at a Time. # Time Info
Date=`Date+%y%m%d ' #time_now1=`Date+%y%m%d-%h:%m:%S ' #dir InfoBackup_dir="/app/dbbackup/full_backup/"Today_dir=
Tags: blog http tar com get useFor developers, database backup is very important, whether it is a normal development of the version of the maintenance or operation of data backup, yesterday back up the database when the problem is sorted out for your reference:This article is taking SQL Server R2 as an example.1. The database itself has its own database backup, i
Regular mysql database backup and mysql Database Backup
I recently used mysql backup and wrote a shell script for backup.
#! /Bin/bash # define the backup database name database = *** # define the backup time currTime =time (dat
Mysql full backup and Incremental Backup implementation method, mysql incremental
Mysql full backup and Incremental backup. Enable the logbin log function of mysql. Add the following code to the/etc/my. cnf file:
[mysqld]log-bin = "/home/mysql/logbin.log"binlog-format = ROWlog-bin-index = "/home/mysql/logindex"binlog_c
After the virtual machine is registered, the next step is to add them as protected items, at the bottom of the menu, click "Protect" to follow the prompts to select the virtual machine you want to protect650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/845013/201603/845013-20160321000045756-436916170. PNG "style=" border:0px; "/>650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/845013/201603/845013-20160321000046474-233904762. PNG "style=" border:0px; "/>
Click Next,
The following articles mainly describe the actual operation steps of DB2 Online Incremental backup, restoration Incremental backup, and Rollback Recovery. The following describes the specific content. If you are curious, the following articles will unveil its mysteries.
Prerequisites for incremental DB2 backup:
1. Change the database parameter logretain, userex
I. Back up the database 1. Open the SQL enterprise controller and click Microsoft SQL Server in the root directory of the console.
2. SQL Server group --> double-click to open your Server --> double-click to open the database directory
3. Select Your Database Name (for example, financial database cwdata) --> click tools in the menu above --> select backup database
4. Select full backup as the
Full-standby batch processing under win
Batch processing is used for game servers, rigorously tested and formally used, and is used primarily to fully back up the database, of course. It's just a few backups.
, the function of FTP can be invoked on a remote server that remotely transmits the backed-up data, which is not described in detail and does not understand
Can be message, can also mail to jzcxfy@opkeep.com
The code is as follows
Copy Code
@echo off@echo ###
Tags: MongoDB full library backup Restore collection backupMongoDB Whole library Backup restore single table collection backup restoreCD D:\MongoDB\bin1 backup of the whole library:Mongodump-h dbhost-d Dbname-o dbdirectory-H:mongdb server address, for example:127.0.0.1:27017-D: The database instance that needs to be ba
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.