Large amount of data backup and restore, is always a difficult point. When MySQL is super 10G, it is slower to export with mysqldump. Recommend Xtrabackup here, this tool is much faster than mysqldump.
First, Xtrabackup Introduction
1. What is Xtrabackup
Xtrabackup is a tool for data backup of InnoDB, which supports online hot backup (without affecting data reading and writing during backup), is a good substitute for the commercial Backup tool Inno
, data restoration(a) Operating procedures1. Using RESTORE HEADERONLYFrom (file name) to view data backup files. After viewing determine which log backup files should be recovered (except for the log backups required during the last two modifications, the remaining restore incremental backups will be available)2. Restore Incremental Backups3.
Tags: style blog color using IO file data art--piecemeal Restore: Database corruption is relatively large, we have to restore the entire database across multiple data files or even across filegroups.--If the database is particularly large, the database recovery time will be very long. However, we can use the piecemeal restore provided by SQL Server to gradually r
to personal database backup and RestorationCode:
/// File name: sqlserverbackuprestore. CS/// Function: Back up and restore the sqlserver Database/// Author: Yang Chun/// Last modification date: 22:35:00Using system;Using system. Data. sqlclient;
/// /// Summary of sqlserverbackuprestore/// Sqlserver data backup and Restoration/// Public class sqlserverbackuprestore: idisposable{Private string _ servername = string. empty;Private string _
This paper mainly introduces the method of restoring the Totolink router to factory setting. There are 2 ways to restore the Totolink router to the factory setting: 1, log on to the Setup interface, restore under the System Tools option, 2, and press and hold the reset button to restore the factory settings. These 2 methods have their pros and cons, the following
Tags: buffer font its TAF inpu dev input automatic targeA friend gives the PDB a restore/recover process.A secondary instance is actually created, then the PDB is extracted and recovered. (10:31:59)Frank.yan: [administrator.win-7zfxnfksd8p]?./rman Target/Recovery manager:release 12.1.0.1.0-production on Fri 19 14:44:05 2017Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.Connected to target DATABASE:ORCL (dbid=1471571033)rman> AL
It is necessary to understand his role before using the Restore Wizard is a software to protect the data on the hard disk. It can write data to the partition table of the hard disk. So it has the highest privilege of almost any soft operation on the hard disk. A hard drive protected by a Restore wizard that can be declared invalid by the Restore Wizard by any dat
11gR2 RAC exclusive mode replace votedisk encounters PROC-26, restore ocr encounters CRS-4000, PROT-35, proc-26crs-4000
Link: http://blog.itpub.net/23135684/viewspace-748816/
The storage data of the 11gR2 RAC system is completely lost. The software of all nodes is installed on the local disk, and the local disk retains the OCR backup, the following describes how to restore the normal operation of Clusterwar
1. Complete recoveryEnterprise Manager -- Right-click "Database" -- all tasks -- Restore database-- Enter the restored database name in "Restore to Database" and set it to test.-- Restore select "from device" -- select device -- add your backup file-- OK. Return to the database restoration page.-- "Restore backup set",
In order to solve problems in our computer, we can restore the problem as soon as possible, many users have set a key restore command on their computers, but sometimes we inadvertently point to this command, how can we avoid this problem? Today's little book teaches you how to hide a key restore command.
Hide Method:
Step One: Open Explorer, set the folder vi
: 192.168.1.108 Tue Dec 3 06:11:41.618 DATABASE: tank to /home/zhangy/mongodb/tank Tue Dec 3 06:11:41.623 tank.system.indexes to /home/zhangy/mongodb/tank/system.indexes.bson Tue Dec 3 06:11:41.623 2 objects Tue Dec 3 06:11:41.623 tank.contact to /home/zhangy/mongodb/tank/contact.bson Tue Dec 3 06:11:41.669 2 objects Tue Dec 3 06:11:41.670 Metadata for tank.contact to /home/zhangy/mongodb/tank/contact.metadata.json Tue Dec 3 06:11:41.670 tank.users to /home/zhangy/mongodb/tank/users.bson
A code that can penetrate the restore card and restore the software
CVC/GB, the wind-like man
Restore cards and restore software are widely used in a variety of public places, such as school rooms and internet cafes. These restore cards and
Restore Wizard is a backup of the C disk software, its core is actually ghost software, and Ghost manual backup is different, a key Restore Wizard in the last part of the hard drive in the last section of the partition, to store the backup. In order to protect the backup files (prevent accidental deletion, prevent the disk from being corrupted, etc.), the partition is hidden and cannot be seen in my compute
Copy Address: Https://www.linuxyw.com/download/xtrabackup.pdfhttp://www.linuxyw.comemail:[emailprotected] Xtrabackup to MySQL database backup and restore this document, just a simple study of the next, for the database full and ready to add, the effect is good because there is no demand for this software, so, the document is not perfect, and so there is time, and then to improve it this document information, Internet collection into my blog: http://ww
Full and differential backup of SQL ServerA full backup is, of course, a backup of all the database dataA differential backup, however, refers to a backup of the changes to the data after the last backup.Therefore, differential backups cannot be used alone, and you can restore a differential backup only after the last full backup was first restored.When you have multiple differential backups, you only need to select a differential backup file for the
when one day the machine fails to come, or the hard disk is broken, for not to get up, if it is a system problem, reinstall the system; If it is a hard disk problem, replace the hard drive, reinstall the system, when the system is installed, you need to install Windows Server Backup function, because we are using it to back up, all restores also need it;Active Directory restore requires attention:if it is restored directly in the system, this error wi
Step One: Click "Start" in the lower left corner of the screen, locate and open the Control Panel, and then find the "Backup and restore Options" in the many options in the Control Panel, and then click Open. As shown in figure:
Step two: Then select "Restore system settings and Computers" In the Backup Restore window. Small editing tips: If your com
Tools/raw Materials
One-click Restore software
Steps to download and install a key restore software
First download a key restore software on the network and run the install by double-clicking the installation package:
Click the "Next" button in the first interface that is ejected by the installer to continue:
In the Pop-up Software
:
#mysql-U root-p
>use school;>insert into info (name,score) values (test02,90);>quit//完成数据插入
#mysqladmin-U root-p flush-logs//refresh generate MySQL Incremental backup log file#cd/usr/local/mysql/data/#ls//binary log has been generated
When the worker inadvertently removes the test01 and test02 users, causing the database to be unavailable, and the full data for the backup is only Zhangsan and Lisi accounts,You need to
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.