I’m hearing a lot of “NoSQL” these days. To really understand how (and) does it works, I decided to give a try on MongoDB.<\/p>\n
MongoDB (hu*mongo*us) is an open source, scalable, high-performance, schema-free, document-oriented database written in the C++ programming language.<\/p>\n
MongoDB is not a Relational Database Management System. The database manages collections of JSON (JavaScript Object Notation)-like documents which are stored in a binary format referred to as BSON (Binary JSON).<\/p>\n
This post will surely get you started with the MongoDB-NoSQL.<\/p>\n
If you want to change default data directory location:
\nFull\\path\\to\\mongod.exe –dbpath=”\\”full\\path\\to\\”” –install<\/p>\n
Troubleshooting Mongodb Installtion Error: Go to:\u00a0HKEY_LOCAL_MACHINE\/SYSTEM\/CurrentControlSet\/Services\/<\/em> This seems to be caused by not giving full-path while installing.<\/p>\n Add Environment variable Path<\/em>, add path\/upto\/mongo-bin-dir;<\/p>\n Okay, now we’re all set to checkout the MongoDB-NoSQL world.<\/p>\n There is a GUI Admin tool available phpmoadmin to simplify the MongoDB Operations. In case of error you may install Microsoft Visual C++ 2008 SP1 Redistributable Package (x86) [www.microsoft.com\/downloads\/details.aspx?familyid=A5C84275-3B97-4AB7-A40D-3802B2AF5FC2&displaylang=en]<\/p>\n Create CSV from MySQL: Import CSV to mongodb using mongoimport: On Command Prompt: By default it’s connecting to test database. Basic Commands Set Current Database: See Present Database: View collections (tables) under present db: SQL>Select count(*) from TABLENAME: SQL>select * from TABLENAME where field1 regexp ‘enrique’: For simple find: SQL>Select field1 from table where field2=”%search%”: SQL>Select All but one (field1) column: SQL>Select with sort order ascending and descending (1,-1):
\n<\/strong> I faced while installing, if you get error like:
\n dbexit:
\nshutdown: going to close listening sockets.
\nshutdown: going to flush oplog…
\nshutdown: going to close sockets…
\nshutdown: waiting for fs preallocator…
\nshutdown: closing all files…
\ncloseAllFiles() finished
\ndbexit: really exiting now<\/em><\/p>\n
\nCheck for MongoDB<\/em>
\nVerify the value of ImagePath <\/em>is proper<\/p>\nMongoDB GUI Administration Tool:<\/h1>\n
\nSignle php script: phpmoadmin
\nDownload PHP extension from php.net\/manual\/en\/mongo.installation.php
\nExtract in ext directory of WAMP & Restart.<\/p>\nMySQL to MongoDB Database Migration:<\/h1>\n
\n mysql> select * into outfile “c:\/TABLENAME.csv” FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\\n’ from TABLENAME;
\nQuery OK, 293911 rows affected (1 min 8.17 sec)<\/em><\/p>\n
\n<\/em><\/p>\n
\n C:\\>mongoimport -d DATABASENAME -c TABLENAME –file “c:\\TABLENAME.csv” –type csv -f FIELD1,FIELD2…<\/em><\/p>\nUsing MongoDB on Windows:<\/h1>\n
\nC:\\MongoDB\\mongodb-win32-i386-1.4.0\\bin>mongo.exe
\nMongoDB shell version: 1.4.0
\nurl: test
\nconnecting to: test
\ntype “exit” to exit
\ntype “help” for help<\/p>\n
\nDefault mongodb port is 9999.<\/p>\n
\n<\/strong><\/p>\n\n
Simple Queries with MongoDB:<\/h1>\n
\n>use DATABASENAME<\/em><\/p>\n
\n<\/em><\/p>\n
\n> db
\nDATABASENAME<\/em><\/p>\n
\n<\/em><\/p>\n
\n > db.getCollectionNames()
\n[ “TABLENAME”, “system.indexes” ]<\/em><\/p>\n
\n<\/em><\/p>\n
\n NoSQL> db.TABLENAME.count()
\n238735<\/em><\/p>\n
\n<\/em><\/p>\n
\n NoSQL>db.TABLENAME.find( { field1 : \/enriqu\/i} );<\/em><\/p>\n
\n<\/em><\/p>\n
\n NoSQL>db.TABLENAME.find( { field1 : “value” } );<\/em><\/p>\n
\n<\/em><\/p>\n
\n NoSQL>db.TABLENAME.find( { field2 : \/search\/i} , {field1 : 1 } );<\/em><\/p>\n
\n<\/em><\/p>\n
\n NoSQL>db.TABLENAME.find( { field2 : \/search\/i} , {field1 : 0 } );<\/em><\/p>\n
\n<\/em><\/p>\n
\n NoSQL>db.TABLENAME.find( { ar_name : \/enrique\/i }, {field1 : 1 } ).sort({ field1 : -1})<\/em><\/p>\n