Want to know offsite data backup storage and disaster recovery? we have a huge selection of offsite data backup storage and disaster recovery information on alibabacloud.com
Day04First, manage the root user password1.1 Change Password1.2 Recover PasswordSecond, user authorization and REVOKE authority2.1 Licensing2.2 Revoke permissionsIII. installation of graphical management toolsFour-data backup and recovery-----full backup and recovery4.1 Full backup4.2 Full
Backup: in the computer application field, it refers to a copy of a program or file separately stored from the original text.
Mysql data backup and recovery
What is backup )?
Backup: in the computer application field, it refers to
Backup and restore of Oracle database users and tables can be done quickly and easily using the Plsql-developer tool.Full backup and recovery of Oracle database user data1. Backup1.1 pl/sql-> Tools, export user objects, optionsCommon user objects include the following:Table,sequence,view,package,type,function,procedure,package Body,treggerSelect the user object t
-p123--all-databases > D:\\all.sql2. Restoring a logical backup# method One:mysql-uroot-p123 day47 d:\\day47.sql (to have day47 Library in advance)# method Two:create Database Day47;use Day47;source d:\\day473. View data in a database without entering the database4. Database migration (Extended understanding)be sure to migrate between the same versions # mysqldump-h source ip-uroot-p123--databases db1
. [Email protected] bin]#/mongodump-d my_mongodb-o my_mongodb_dumpConnected to:127.0.0.1Database:my_mongodb to My_mongodb_dump/my_mongodbMy_mongodb.system.indexes toMy_mongodb_dump/my_mongodb/system.indexes.bson1 objectsMy_mongodb.user to My_mongodb_dump/my_mongodb/user.bson2 objects[Email protected] bin]#In this example, the backup file exists in the My_mongodb_dump directory under the current directory Data
The importance of database backup and data recovery, I think you know, here is an example of how to manipulate data backups, examples of data recovery:
Creating test data
Create Db:te
RMAN to back up the database. Here I only backed up the data files that are prepared to create bad blocks for quick experiments.
[Oracle @ bys001 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Fri Sep 13 13:28:36 2013Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.Connected to target database: BYS1 (DBID = 3957527513)RMAN>
/bin/redis-cli-h 127.0.0.1-p 6379-a pwd bgrewriteaof
We are now doing is a master (master) more from (Slave), the main library does not open aof persistence, just back up every day rdb[the official advice is to back up the Rdb file every hour, see your strategy], and on the library to open aof backup, The corresponding backup file is pushed to the backup
First, we download and run the Usboot, and then insert the U disk, Usboot will find the newly inserted u disk:
First, select the U disk;
Second, click "Click here to select the mode of work" pop-up menu, select "Back to File" menu item;
Third, then click on "Start";
Four, at this time, Usboot will pop up a "Backup U disk for File" dialog box, enter a name such as: "Backup_disk_u", and then click Save.
Please wait patiently for usboot work until y
/mysql.sock-b sky9896 blog >/home/tools/bak_b_$ (dat e +%f). sql4) How do I make a sub-library backup? Mysqldump-u User name - P Database > backup file name . SQL[Email protected] tools]# mysqldump-uroot-p-s/var/lib/mysql/mysql.sock blog >/home/tools/bak_b_$ (date +%f). sql5 How do I make a backup of a table? Mysqldump-u User name - P Database name Table name 1
modified, Save 60 10000//(these 3 options are masked, the RDB is disabled) Stop-writes-on-bgsave-error Yes//background backup process error, the main process stops writing rdbcompression Yes/ If the Rdb file is compressed rdbchecksum Yes//import RBD recovery data, do not verify the integrity of the RDB Dbfilename Dump.rdb//the RDB filename dir.///rdb Placement P
the MyData container, such as:DB1 Mount
[Root@localhost ~]# Docker run-it--volumes-from mydata--name db1 Debianroot@9a42647f5a2d:/# Cat Mydata1/data.txt2016-09-01-04:14:35root@9a42647f5a2d:/#
DB2 Mount
[Root@localhost ~]# Docker run-it--volumes-from mydata--name DB2 Debianroot@8f7738f2f159:/# Cat Mydata1/data.txt2016-09-01-04:14:35root@8f7738f2f159:/#At this point, no matter where the modification will be synchronized, of course, you can also use the--volumes-from parameter multiple times to
Oracle backup and recovery of single or multi-table data
Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10.*Back up single or multi-table data:Exp user/password @ Server File = filefullpath
Chat is a byte in modern networks, especially for young friends. The two-day well-known software includes QQ series and ICQ. The former is the most widely used chat tool for Chinese people, and the latter is the most popular chat tool in the world. Of course, Microsoft's MSN chat tool is also a frequently used chat tool. Since the users who chat on the Internet are basically people they know, they often need to save relevant information. At this time, it is very necessary to use
One time with friends to discuss the net-buffer-length may have an impact on the mysqldump export and recovery, test it, found that the impact is very small, the basic can be neglected, the following is the comparison test results.Description: When executing mysqldump, the maximum limit for net buffer length is 16Mb, the default value is 1Mb, and the following is the test result map:650) this.width=650; "Src=" Http://dp.imysql.com:8080/files/upload_ye
Computers give us too much convenience. If there is a lack of computers in modern life, I can't imagine what it will become. However, computers, like humans, often get "sick". If they are serious, they will cause data losses, which can be a big headache for users. Of course, to prevent this type of incidents, smart humans have developed many powerful data backup
Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10.
* Back up single or multi-table data:
Exp user/password @ server file = filefullpathname log = logfullpathname tables = (tablespacename. table1, tablespacename. table2 ,...)
For example, the author wants to export
Data Recovery Failure Description:The original storage is a 12 2T hard disk composed of Linux RAID6, the file system is EXT3, this storage is zoned 3 LUNs, each 6TB size, one day after the raid failure, maintenance personnel in order to salvage the data, the failure of the
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.