Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Sep 062011
 

Select a document in MongoDB

Answer:

To select (find) a document in MongoDB, you can use the following syntax in the mongodb Interactive shell.

use my_db
db.users.find({name:"peter"})

You need to switch to the current database (e.g. my_db) and then execute your select statement.

Aug 252011
 

Disable MySQL server from listening for TCP/IP connections

Answer:

If you only connect to the MySQL server from localhost and you might want to disable TCP/IP networking feature so the server is more secure.

To do so, edit the MySQL configurations, e.g. /etc/my.cnf

..
skip-networking
..

Don't forget to restart MySQL to take effect.

# /sbin/service mysqld restart

Aug 192011
 

Repair and compact database in MongoDB

Answer:

To repair and compact a database in MongoDB, you can use the following command in the mongodb Interactive shell.

1. Select the database

use test

2. Repair the current database

db.repairDatabase()

Done.