When our DB2 database suffers database corruption due to some serious errors (such as storage corruption), we usually need to fix the related errors, use the Restore command to Restore the database (DB2 also supports high system availability through multi-machine fault tolerance mechanisms such as HADR. This article only damages the single-host database, database recovery is required ). The general practice is to restore the whole database through the
restoring the database.
I. use Discuz! Back-end database backup
1. to ensure that the backup data is complete and correct, ask the webmaster to close the site before backing up the data;
2. use the webmaster permission to log on to the backend -- webmasters -- database -- Backup
Windows 7 is getting closer and closer to us. I believe many of my friends have already experienced Windows 7 versions. If you use a Windows system, you cannot do without backup and restoration. Speaking of System Restoration and restoration, you will surely think of ghost. That's right. Now, after installing the system, making a ghost backup can be said to be es
In SQL Server, regular database backup is required for data security considerations. The backup database is generally performed in the early morning when there are basically no database operations, so we cannot ask the Administrator to back up the database at every day. To implement regular automatic database backup, the most common method is to
Copy-only Backup is a way of backing up from a traditional SQL backup method. In general, doing a database backup can affect subsequent backup and restore jobs. However, there are times when you need to make a backup for a specific purpose but don't want to affect your datab
MySQL -- use xtrabackup for backup and restoration, and mysql -- xtrabackup
Use the rpm package to install xtrabackup
# Install dependency package yum-y install perl-devel libaio-devel perl-Time-HiRes perl-DBD-MySQL rsync # install libev4 package rpm-ivh libev4-4.15-7.1.x86_64.rpm # install percona-xtrabackuprpm-ivh percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
C
Mysqldump is often used in MySQL database logical backups.
1. Various usage instructions
A. The simplest use:
Mysqldump-uroot-ppassword [database name]
> [dump file]
The above command backs up the specified database to a dump file (dump file), for example:
mysqldump-uroot-p123 Test > Test.dump
The generated Test.dump file contains the Build table statement, which generates the database structure, and inserts the data into
Why percona-xtrabackup
We have discussed MySQL Cold Standby, Hot Standby, mysqldump, and hot copy to ensure data consistency. Because mysql cold backup, mysqldump, and mysql hot copy cannot achieve Incremental backup, Incremental backup is used in a large number of actual environments, and percona-xtrabackup is generated for Incremental
, you can modify alterbackup. sh in step 1. The Modification result is as follows (in bold, this statement needs to be modified according to the database installation situation ):
......
Chmod + x backup. sh
Cp/u01/app/oracle/admin/orcl/pfile/initorcl. ora backup/initorcl. ora
. Backup. sh
# Note: there is a space between the dot "." And
Backup | recovery | Hot BACKUP | data
Use hot backup for time-sharing recovery
----How to recover incrementally from archiving to shorten data migration time
Last Updated:monday, 2004-11-15 10:32 eygle
A lot of times you may encounter a situation like this:
The migration of a large database, but with little do
an idea! hehe. Operating System: CentOS Release 6.5mysql:5.6.21First, installationYum Install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpmYum Install Percona-xtrabackupSecond, start to useXtrabackup contains several tools for Innobackupex,xtrabackup,xbcrypt,xbstream. Innobackupex supports MYISAM,INNODB. All, I choose to use Innobackupex.1. Create a backup u
be backed up is a module. The two paths correspond to [appbackup] and [databackup] respectively.
3. Create a new password file/etc/rsyncd. scrt. The corresponding content is as follows:
Backup: configurebackup @ # $ ^ * () googleUser: passwordpassword
Here there are two users: backup and user. The colon corresponds to the password. Note that the attribute of this file is 600 (other users do not have the r
In order to ensure the recoverability of the data in the server, a remote backup database scheme is used. Offsite backup data are divided into off-site backup file data and off-site backup database data two kinds. The off-site backup file data is designed to back up files up
/*--------------Interface--------------*/if (!$_post[' act ') {/*----------------------*/$MSGS []= "Server backup directory is $backup";$MSGS []=] for larger data tables, it is strongly recommended to use a sub-volume backup ";$MSGS []=] only choose to backup to the server i
end the current log, generate a new log file;The --master-data=2 option will record 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; 3.MySQLdump Incremental Backup Additional instructions:If M
The AppleMacOSX system comes with an easy-to-use backup software TimeMachine. "TimeMachine automatically saves the latest versions of all content in Mac, including photos, music, videos, and documents, applications and settings. As long as necessary, you can easily roll back time and restore any files .", To use TimeMachine, you must
control file, which is a text file. Step 4: alter database backup controlfile to '/backup/pancontrol. Bak'; back up the current control file. Step 5: Create a tablespace, create a table in the tablespace, and add data. The purpose is to change controlfile to a new one. Create tablespace ts_test02 datafile '/u01/oradata/pan/ts_test02_01.dbf' size 10 m; sqlplus scott/tiger create table tb_test02 (id int) tab
For data security considerations, You need to regularly back up the database in SQLServer. The backup database is generally performed in the early morning when there are basically no database operations, so we cannot ask the Administrator to back up the database at every day. To implement regular automatic database backup, the most common method is to use the SQL
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.