Skip to main content

Import and Export using OPLOG.RS in MongoDB

Edit mongod.conf  to add replicate set

sudo vi /etc/mongod.conf

Add this following lines in mongod.conf

replication:
  replSetName: rs0
  oplogSizeMB: 1024

Then restart mongod by "sudo service mongod restart"

Check for mongo status if everything is fine

sudo service mongod status

if everything is OK you get this result otherwise please check/var/log/mongodb/mongod.log for any errors.

mongod start/running, process 5806

Now go to Shell prompt and type 
>mongo
Then type
> use  //To change your working DB
> rs.initiate()
{
"info2" : "no configuration explicitly specified -- making one",
"me" : "jamesnirmal:27017",
"ok" : 1
}

Now command prompt will changed to 

rs0:PRIMARY>

Now type

rs0:PRIMARY> use local

rs0:PRIMARY> show collections
me
oplog.rs
startup_log
system.indexes
system.replset

MongoRestore:

Now go to Normal shell and create one folder called oplog

and type this following command to create mongo dump under oplog folder.

mongodump --port 27017 -d local -c oplog.rs --query '{"ts" : {$gte: Timestamp(1502285060, 1)}}' -o ./oplog/

Then type cd oplog/local/

mv oplog.rs.bson oplog.bson

rm oplog.rs.metadata.json //if exist

run this command to Destintion server all data will be updated automatically

mongorestore --port 27017 --oplogReplay ./oplog/local/

To verify your changes please type ;

 db..find();

Comments

Popular posts from this blog

Configure Alfresco in Ubuntu 10.4 LTS

Pre-Requisition 1. Mysql 2. Image Magic 3. Swftools 4. Open Office 5. Alfresco Community Edition 3.2 To update apt source.list 1. open source.list using vi /etc/apt/sources.list 2. enable all debian url To update Latest apt-get Repository 1. sudo apt-get update To Install 32 Bit Software sudo apt-get install ia32-libs To Install MySql 1. apt-get install mysql-server To Install Sun Jdk 1. aptitude install sun-java6-jdk 2. ./jdk-6u20-linux-x64.bin 3. mv jdk1.6.0_20/ /usr/local/java 4. chmod a+rx -R /usr/local/java 5. open vi /etc/profile 6. export JAVA_HOME=/usr/local/java 7. export PATH=$JAVA_HOME/bin:$PATH 8. export CLASSPATH=.:$CLASSPATH:$JAVA_HOME/lib/tools.jar To install Open Office (If Really Needed) 1. If open office is not installed then please download the Open Office click here 2. mv OOo_3.2.1_Linux_x86-64_install-deb_en-US.tar.gz /opt/ 3. cd /opt/ 4. tar zxvf OOo_3.2.1_Linux_x86-64_install-deb_en-US.tar.gz 5. cd OOO320_m18_native_packed-1_en