Skip to main content

Posts

Showing posts from 2017

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 crea

MYSQL Upgrade from 5.5 to 5.7 in UBUNTU 14.04 LTS

wget http://dev.mysql.com/get/mysql-apt-config_0.7.2-1_all.deb sudo dpkg -i mysql-apt-config_0.7.2-1_all.deb sudo apt-get update apt-key list sudo apt-key adv --keyserver pgp.mit.edu --recv-keys A4A9406876FCBD3C456770C88C718D3B5072E1F5 sudo apt-get update mysql -V sudo apt-get install mysql-server mysql --version