-named directory; the Innobackupex command creates a Backup-dir directory to store the backup data.Binary version http://www.percona.com/downloads/XtraBackup/wget http://www.percona.com/downloads/XtraBackup/LATEST/binary/Linux/x86_64/percona-xtrabackup-2.0.3-470.tar.gzTar zxvf percona-xtrabackup-2.0.3-470.tar.gzCD Percona-xtrabackup-2.0.3/binCP */usr/bin/The use of this mysql5.5.28 installation is not descr
Let's talk about the background of the problem. You can skip it later. I am a 15-inch rMBP2012. The day before yesterday, I got stuck on the login interface (a rare problem is that after entering the password, the circle turns endlessly. Of course, the system cannot go in ). I just got started with mac and didn't understand anything. I simply used the disk permission repair and disk verification, and there was no problem. So I went to the app store for detection and re-installed it directly. If
Database backup and recovery (learning notes), backup learning notes
-- ********************** Data Pump Technology ------ oracle 10 Gb later appeared
-- Create a directory
Create directory dump_dir as 'e:/backup ';
-- Query all directories in the database
Select * from dba_directories;
-- Delete the database directory
name, if not this line, indicates that it is anonymous secretsfile=/etc/backserver.pas # specifying the authentication password file location5. Provide the authentication file, and the permission must be 600# Vim/etc/backserver.pas root:123456# chmod 600/etc/backserver.pas6. Restart the service#/etc/init.d/xinetd Restart7. Synchronizing backups to 192.168.40.162Provide the authentication file, and the permissions must be 600# Vim/etc/backserver.pas 123456# chmod 600/etc/backserver.pas# mkdir-p/
the name of the new log file after the full backup in output SQL.References for later recovery, such as the output of a backup SQL file, contain:Change MASTER to Master_log_file= ' mysql-bin.000002′, master_log_pos=106;Mysqldump Incremental Backup Additional instructions:If Mysqldump plus –delete-master-logs clears th
Brief introduction
1 • Concept of full and incremental backups2 • Full backup with mysqldump3 · Using Mysqldump for table structure backup4 • Two methods of full backup recovery5 • Incremental backup with flush logs6 • Incremental Backup recovery7 · Based on point-in-time and seat recovery8 · MySQL
Format reload system, only to think of Oracle 10g database did not do backup, began to think very troublesome, did not expect the database recovery is quite smoothRecovery method:1, the original database file backup, (D:\ORACLE\PRODUCT\10.2.0\ORADATA\GQXT), rename it, I named Gqxt_old, (otherwise the database will be prompted when the SID already exists).2, re-in
libraries, add build-up statements and
use statements--compact Remove comments, suitable for debug output, production without-
f flush Binlog log
-- Master-data Add binlog log file name level corresponding location point-
R backup stored procedure such as-
x Lock table-
l--lock-tables read-only lock table-
D only Back table structure-
t Back up data only--single-transaction for innodb Things database back
Recovery Based on backup control file (unsing backup controlfile)
Applicable:Recovery Based on backup control files is applicable to the following situations: the tablespace is accidentally deleted; all control files are damaged.
1. Close the database and perform a full-database cold
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. Ch
This article mainly introduces how to use cold backup in the real environment of MySQL backup and recovery. if you need it, refer to the previous article (cold backup of MySQL backup and recovery. However, there is a problem. The
Tags: RMAN ORACLE zhangIntroduction: Welcome to add QQ Exchange 1445696451 Weibo address http://blog.51cto.com/13434336~~~~~~~ Split~~~~~~Database backup and recovery is what the database administrator must master. No system can be protected from physical damage to the hard disk, careless user error operations, or potential disasters that could threaten to store data. In order to maximize the
database, multiple databases, all databases, or you can back up a single table in a database, multiple tables.(2) Differential backup: Backs up files that have been modified since the last full backup, only part of the database is backed up, but the storage and recovery speed is fast.(3) Incremental backup: Only those
-- ====================================
-- Oracle backup recovery concept
-- ====================================
During database maintenance, backup or recovery is the top priority. Although the database system runs slowly in many cases, it is clear that the cost of the latter is the loss of database data.
It is self
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.