I.
What is full backup, differential backup, and Incremental backup?
Introduction to Backup Types and combined backup solutionsFull backupBacking up all selected folders does not depend on the file archive attribute to determine
-52-43/
[Root @ local-db opt] # innobackupex -- defaults-file =/etc/my. cnf -- user = root -- password = 123456 -- copy-back/bak/mysql/2015-07-08_18-52-43/
There are two steps for recovery:
The first step is apply-log. to speed up, we recommend that you set -- use-memory. After this step is completed, the backup files under the/bak/mysql/2015-07-08_18-52-43/directory are ready.
Step 2 is copy-back, that is, copy the
, according to this information, can easily use Backup to redo slave.3. Official documents: Http://www.percona.com/docs/wiki/percona-xtrabackup:startB, what can xtrabackup doOnline (Hot) backup InnoDB, xtradb tables for the entire libraryIncremental backup based on Xtrabackup's last backup of the whole library (InnoDB
Nine Incremental backups
With incremental backups, RMAN allows users to back up only blocks of data that have been modified since the last incremental backup. Incremental backups have the following somewhat:
(1) Less use of disk or tape
(2) Reduce network broadband requir
---------- Full backup -----------Backup set: block backup used in data filesImage copy: a complete copy of all data files.---------- Incremental Backup -----------A backup of a database that has changed since a specific time poin
The company's Linux server uses a common desktop and lacks a disaster recovery mechanism. The company stores a large amount of data on this server. Once a fault occurs, the consequences are unimaginable. Therefore, it is necessary to effectively back up important data of this machine. After several days of data collection, I finally compiled my own Linux script to implement a complete monthly backup and daily Incr
MySQL backup and recovery-percona-xtrabackup incremental backup and recovery bitsCN.com article review
In the previous article, we talked about the use of percona-xtrabackup software. This article describes how percona-xtrabackup achieves incremental backup and recovery.
2
Oracle rman backup and RestorationRMAN supports Incremental Backup: databases, tablespaces, and data files.Only used blocks can be backed up as backup setIng between tablespaces and data files: dba_data_files/v $ datafile_headerIn noarchivelog mode, you can use RMAN to back up the read-only and offline tablespaces.Orac
] full]# cp-r/backup/mysql/full/2015-05-07/2015-05-07_18-14-25/ib*/var/lib/mysql/# If the InnoDB data file is placed in a separate directory, it needs to be copied separately[[email protected] full]# chown-r Mysql:mysql/var/lib/mysql # Modify owner, owning group[[Email protected] full]# service MySQL start[[email protected] full]# mysql-u root-p123456789 # Login Database View data has been restoredMariaDB [(None)]> show databases;+--------------------
Instance method for mysql automatic incremental backup (local backup and remote backup) bitsCN.com
1. local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:Cd/data/home/mysqlbakRq = 'date + % Y % m % d'/Usr/local/mysql/bin/mysqldum
Set in cron and execute at every Monday (full backup every Monday, Incremental backup for the rest of the time)
# Vi backup. Sh
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->#! /Bin/bash
# Define
Dayofweek = 'date "+ % u "'
Today = 'date "+ % Y % m % d "'
Sour
During traditional Oracle backup, database files are backed up by copying operating system files. The backup granularity is data files, and the data files may be large, however, it is empty blocks and there is no Oracle data, but because it is a file copy, you need to back up the entire file.The backup set value of RAMN backs up used data blocks and supports
MYSQL database automatic local remote dual-backup MYSQL incremental backup to build a high-security E-commerce website (automatic local/remote dual-backup of website files and databases) architecture diagram
We will continue to introduce the e-commerce system architecture related to file
The following articles mainly describe the correct operation steps for offline and online full backup, Incremental backup, and recovery of DB2, the following is a detailed description of the correct operation steps for DB2 offline and online full backup, Incremental
Tags: full backup incremental backup data restoreScenario: Sunday full Backup, Monday, Tuesday incremental backup, Wednesday problems, found after a few minutes;Installation of the database:
yum install mariadb-server-y
systemctl
Intended audience
This article is tested in linux and mysql 4.1.14. After modification, it may be applicable to mysql 4.0, 5.0 and other versions.
This article is applicable to mysql that does not enable replication. If replication is started, you may not need to adopt this backup policy or modify relevant parameters.
Each person may have different backup policies. Therefore, Please modify the policies base
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.