Because it is a backup of a database of the same name on another computer, restore with the normal method, the hint is not the same database, do not let restore, find the following method on the net to solve:
One, right click System Database master, new query
Execute the following SQL code:
RESTORE
When dealing with databases, it is inevitable that data backup and recovery will occur. The following are the instructions used. I will leave them here for the time being. Data backup: E: mongodb-win32-x86_64-2.2.1binmongodump.exe -- dbCpsCommodityInfoE: mongo30329 data recovery: E: mongodb-win32-x86_64-2.2.1binmongore
MySQL database backup and recovery methods, mysql Database BackupMySQL database backup and recovery methodsMysql-uroot-pShow databases;1. Export the database1). MySQL command line to export the entire database (including data)The
Php backup database sharing, php backup database
Php backup database class sharing
The above is all the content of this article. I hope you will like it.
1. Full database backup: Divided into archive and non-archive by archive mode
Archive mode
Open state, non-consistent backup
Off state, can be divided into consistency and non-conformance
Non-archive mode
Open, non-consistent backup invalid
Shutdown status, consistent backup
1. Full database backup: Divided into archive and non-archive by archive mode
(1) Archiving mode
Open state, non-consistent backup
Off state, can be divided into consistency and non-conformance
(2) Non-archive mode
Open, non-consistent backup invalid
Shutdown status, consistent
it is to back up the database. The following describes how to back up and restore the database with ORACLE7 as an example. ORACLE databases have three standard backup methods: EXPORT/IMPORT, cold backup, and hot backup. Exporting backup
or other tools to copy files. However, copying multiple files is not an atomic operation, you must stop all writes before copying, otherwise the copied data may be in an inconsistent state.2. MongodumpBy copying the underlying file does not support point-in-time recovery (point-in-time recovery) of the complex set (replica set), and it is difficult to manage large shard clusters. In addition, these copies are large because they contain indexes and the underlying padding and fragments. and mongo
We usually create
BackupIn
SQL Server, We can achieve this through the following method:
Steps for automatic backup in SQL Server 2005 database:
1. Open SQL Server Management Studio
2. Start the SQL Server proxy
3. Click job> create job.
4. Enter the job name in "regular"
5. Create a step, select the T-SQL type, and enter the following statement in the following command (the red part should be changed acco
Here, we use the LVM Logical Disk for speeding backup of Mongodb. mongodb has reached dozens of GB or more. The speed of using the mongodb tool for backup will make us feel quite slow, at this time, we can run the mongdb data directory.
Here, we use the LVM Logical Disk for
Tags: name r2 Administrator server specified instance SM bubuko infSystem environmentServer System: Windows Server2012 R2 mongodb:v3.4.4 You can view version information by command: mongo-version Scenario: Back up the database smp_maint_2, and revert to the new database Smp_maint_2_restore.MongoDB Database Backup1. Syntax:Mongodump-h dbhost-d Dbname-o dbdirector
MongoDB Standalone:To back up all libraries:Mongodump--host 10.10.7.33:27019--gzip--OUT/HOME/MONGODB/0415_BFTo back up the specified library:Mongodump--host 10.10.10.251:21100-d dbname--gzip-out/home/mongodb/bjdata2Restore recovery:Mongorestore--host Replica backup of the set cluster:Backup Data set:mongodump -h"ttlsa/
Label:Building a MongoDB server1. Download MongoDB installation files, this example according to the Mongod version of 2.6.5 as the standard mongodb-linux-x86_64-2.6.5, after the 2.6 version of the permissions of MongoDB enhanced. This is my Baidu cloud mongodb2.6.5 linux64 bit of resources file, can be downloaded acco
Tag: OOB file Data cal Objectid Error:god exists backup fileBackup:Mongodump-h localhost:27017-d test-o "D:\DATA\DB1"To restore a backup:D:\mongodb\bin>mongorestore-h localhost:27017-d test--drop "D:\data\db1\test"If you do not add--drop you will be prompted with errorserror:e11000 duplicate key error index:test.runoob.$_id_ dup key: {: ObjectId (' 5b076926d2476498526a9d3b ')}Hint that there is data in the
Tags: action start nal first open amp from Percona font1 Overview1.1 IntroductionXtrabackup is a MySQL database backup tool provided by Percona, officially described, which is the world's only one by one open source tools that enable hot provisioning of InnoDB and XTRADB databases.PXB (Percona xtrabackup) is a physical backup, is based on a copy file
MongoDB database installation details (2). mongodb details
How to change mongodb in java
Java-based mongodb insert, read, modify, and delete operationsThis article describes how to operate MongoDB in Java and how to perf
MongoDB database details (1). mongodb details
MongoDB> port 27017
I. What is Nosql (object-oriented storage-key and value)
Ii. CognitionMongoDB (json storage)
How to Create a mongodb database with a user name and
The article introduced two kinds of database record code, one is our PHP write common database backup class, the other is for Linux friends to provide an automatic timing backup MySQL database code, the need for students can refer to.
Save the following PHP code as a backdat
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.