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
............... wuwu .... all are lost. it is still a problem of your own. If it is not a misoperation, it will not lead to such a result.
This kind of thing should not happen at the same time. Let's get started with the question, how to back up data?
Let's talk about the classification of important materials (my personal classification)PasswordWebsite PasswordWebsite password, domain name password, space password, server user passwordDocument
Logical backup (Data migration):Backup in Logical StructureMove data across usersMoving databases across databasesSave the original data state for the testVersion upgrade of a databaseConsiderations for Logical Export:EXP program in the directory found the same name file wil
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
Tags: log root ide parameter grep count Oldboy file nodMysqldump-u User name-p password Mysqldump-h 127.0.0.1-u root-p3003--events-p mysql >/tmp/mysql.bak.sql # # #因为mys Qldump default is not to back up the event table, only add the--events will be resolved plus Egrep-v "#|\*|--|^$"/tmp/mysql.bak.sql ############### #查看导出的表信息 Mysql-h 127.0.0.1-uroot-p ' 123456 '-p3003-e "use Mysql;drop table db;" # #通过命令删除mysql下的db表.Mysql-h 127.0.0.1-uroot-p ' 123456 '-p3003 mysql mysql-uroot-h10.10.0.37-p3320-
SharePoint Data Protection (I) backup site set and sharepoint backupZookeeper
Site Collection Backup
Data is undoubtedly the most important for enterprises. As SharePoint becomes more and more information and document centers, it is also necessary to protect its data.
Here we discuss the backup of the Linux operating system.In the production environment, customers will be required to do a system-wide data backup for a recovery after a system crash. This includes backup recovery of operating system data.As a production environment, customers will require
I used to think that the full backup of SQL Server only backs up the data in the database and does not contain logs. In fact, this is an error. Using RESTOREHEADERONLY can help us verify (msdb. db
I used to think that the full backup of SQL Server only backs up the data in the database and does not contain logs. In fa
This article mainly introduces the partitioning and backup methods of SQL Server data backup files. if you need a friend, you can refer to the following: when backing up a complete database, we may sometimes encounter an extreme situation, for example, only 5 GB space is left for the three drive letters C, D, and E on the server.
But what if we need 12 GB of spa
Multi-Backup is a cloud platform (SaaS) application provider that focuses on backup, recovery, migration, storage, and archiving of business data in the cloud. In order to achieve adequate data security, we have adopted the self-developed cloud 5 technology.The source of the problemIn February 2014, a user hurried to c
Openerp data backup and recovery, openerp backup and recoveryBack up the entire database:Use the backup file to restore the database:Notes:
It is best to write a script to automatically back up data
If you do not stop openerp When deleting a database, a prompt is displ
Http://www.tektea.com/archives/2163.html.In one of the Linux OS backups: Online backup of Linux operating system data using LVM snapshots, we introduce the method of using LVM snapshot to realize the online backup of operational system, and LVM snapshot can realize the backup of the online operating system
Previously thoughtSqlserverA full backup only backs up database data and does not contain logs. In fact, this is an error. UseRestoreheaderonlyCan help us verify (MSDB.DBO.Backupset also contains the corresponding information).
Restore headeronlyReturns the result set that contains all backup header information of all ba
The 11g active data guard implements rman backup for the standby database, so that the database can be backed up without affecting the external services of the primary database.
The test is as follows:
SQL> select OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE from v $ database;
OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE-------------------------------------------------------------
This article describes how to use shell to implement full and incremental mysql backup. Incremental backup copies the mysql-bin.00000 * to the specified directory at Monday-Sat, while full backup uses mysqldump to export all the databases at every Sunday, and will delete the last week left by the mysq-bin.00000 *. Then, the mysql
Generally, you can manually back up the websites in the VPS. Generally, the old man prefers to back up a website once a week. This frequency should be quite good. The "automatic and timed backup of database/website Files" method shared yesterday is more suitable for data, it cannot be maintained in front of the computer for a long time.
For example, some friends often go on a business trip. When they com
MySQL LVM snapshot backup features:
1, in most cases, this approach is almost a hot standby. It does not need to shut down the service, just set a read-only or similar limit.
2, support all local disk based storage engine, such as MyISAM, InnoDB and BDB, also support solid, primext and faction.
3, the fastest backup speed, because you only need to copy the relevant binary
itunes scan will show unknown of incomplete backup data caused by the registration code overrun, this is to back up the collation of data, we look at the deletion method.
The first step, if we use itunes may not be deleted, but we can use the Apple recovery Guru, we open the software and then click the "Help" icon.
Second step, and then click "Open ITunes
Xtrabackup and innobackupex Hot Backup MySQL DataXtrabackup and innobackupex Hot Backup MySQL Data 1. xtrabackup introduction and backup principles Description: Xtrabackup is an open-source software developed by percona. It can quickly back up and restore mysql Databases and supports online Hot
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.