Tag: base font size Field No query exp NTS index CIN
Original: http://www.jb51.net/article/52498.htm
One, Mongodump backup database
1, Common command grid
?
1 |
mongodump -h IP --port 端口 -u 用户名 -p 密码 -d 数据库 -o 文件存在路径 |
If there is no user who can remove-u and-P.
If you export the native database, you can remove-H.
If it is the default port, you can remove--port.
If you want to export all databases, you can remove-D.
2. Export all databases
?
12345678910 |
[[email protected] mongodb]
# mongodump -h 127.0.0.1 -o /home/zhangy/mongodb/
connected to: 127.0.0.1
Tue Dec 3 06:15:55.448 all dbs
Tue Dec 3 06:15:55.449 DATABASE:
test
to
/home/zhangy/mongodb/test
Tue Dec 3 06:15:55.449
test
.system.indexes to
/home/zhangy/mongodb/test/system
.indexes.bson
Tue Dec 3 06:15:55.450 1 objects
Tue Dec 3 06:15:55.450
test
.posts to
/home/zhangy/mongodb/test/posts
.bson
Tue Dec 3 06:15:55.480 0 objects
。。。。。。。。。。。。。。。。。。。。省略。。。。。。。。。。。。。。。。。。。。。。。。。。
|
3, export the specified database
?
1234567891011 |
[[email protected] mongodb]
# mongodump -h 192.168.1.108 -d tank -o /home/zhangy/mongodb/
connected to: 192.168.1.108
Tue Dec 3 06:11:41.618 DATABASE: tank to
/home/zhangy/mongodb/tank
Tue Dec 3 06:11:41.623 tank.system.indexes to
/home/zhangy/mongodb/tank/system
.indexes.bson
Tue Dec 3 06:11:41.623 2 objects
Tue Dec 3 06:11:41.623 tank.contact to
/home/zhangy/mongodb/tank/contact
.bson
Tue Dec 3 06:11:41.669 2 objects
Tue Dec 3 06:11:41.670 Metadata
for tank.contact to
/home/zhangy/mongodb/tank/contact
.metadata.json
Tue Dec 3 06:11:41.670 tank.
users to
/home/zhangy/mongodb/tank/users
.bson
Tue Dec 3 06:11:41.685 2 objects
Tue Dec 3 06:11:41.685 Metadata
for tank.
users to
/home/zhangy/mongodb/tank/users
.metadata.json
|
Third, Mongorestore restore the database
1, Common command format
?
1 |
mongorestore -h IP --port 端口 -u 用户名 -p 密码 -d 数据库 --drop 文件存在路径 |
--drop means to delete all records first and then restore them.
2. Restore all databases to MongoDB
?
1 |
[[email protected] mongodb] # mongorestore /home/zhangy/mongodb/ #这里的路径是所有库的备份路径 |
3. Restore the specified database
?
123 |
[[email protected] mongodb] # mongorestore -d tank /home/zhangy/mongodb/tank/ #tank这个数据库的备份路径 [[email protected] mongodb] # mongorestore -d tank_new /home/zhangy/mongodb/tank/ #将tank还有tank_new数据库中 |
These two commands can be implemented to backup and restore the database, the file format is JSON and Bson. Unable to refer to a table backup or restore.
Four, Mongoexport export the table, or some fields in the table
1, Common command format
?
1 |
mongoexport -h IP --port 端口 -u 用户名 -p 密码 -d 数据库 -c 表名 -f 字段 -q 条件导出 --csv -o 文件名 |
The above parameters are good to understand, focus on:
-F export refers to field, split by font size,-f name,email,age export name,email,age three fields
-Q can export the root query condition,-Q ' {"UID": "100"} ' exports the data with UID 100
--csv means that the exported file format is CSV, which is useful because most of the relational databases are supported by CSV, and there's something in common here.
2, export the whole sheet
?
123 |
[[email protected] mongodb] # mongoexport -d tank -c users -o /home/zhangy/mongodb/tank/users.dat connected to: 127.0.0.1 exported 4 records |
3. Export some fields from the table
?
123 |
[[email protected] mongodb] # mongoexport -d tank -c users --csv -f uid,name,sex -o tank/users.csv connected to: 127.0.0.1 exported 4 records |
4, according to the conditions to dare to out data
?
123 |
[[email protected] mongodb] # mongoexport -d tank -c users -q ‘{uid:{$gt:1}}‘ -o tank/users.json connected to: 127.0.0.1 exported 3 records |
Five, Mongoimport import table, or partial field in table
1, Common command format
1.1. Restore a non-CSV file exported from the whole table
Mongoimport-h IP--port Port-u user name-p password-D database-C table name--upsert--drop file name
Focus on--upsert, the other arguments above have been mentioned,--upsert insert or update existing data
1.2. Restore the export file for some fields
Mongoimport-h IP--port Port-u user name-p password-D database-C table name--upsertfields field--drop file name
--upsertfields Root--upsert like
1.3. Restore the exported CSV file
Mongoimport-h IP--port Port-u user name-p password-D database-C table name--type type--headerline--upsert--drop file name
In the above three cases, there can be other permutations and combinations.
2. Restore the exported table data
?
123 |
[[email protected] mongodb] # mongoimport -d tank -c users --upsert tank/users.dat connected to: 127.0.0.1 Tue Dec 3 08:26:52.852 imported 4 objects |
3. Table data import for some fields
[Email protected] mongodb]# mongoimport-d tank-c users--upsertfields uid,name,sex tank/users.dat
Connected to:127.0.0.1
Tue DEC 3 08:31:15.179 imported 4 objects
4. Restore the CSV file
?
123 |
[[email protected] mongodb]# mongoimport -d tank -c users --type csv --headerline --file tank/users.csv connected to: 127.0.0.1 Tue Dec 3 08:37:21.961 imported 4 objects |
Overall feeling, MongoDB backup and restore, or quite powerful, though a little troublesome.
MongoDB Database Operations--Backup restore Export Import