Shulou(Shulou.com)06/01 Report--

There is a need at work to help extract cashloanDb from a data system.

Involving MongoDB collections: cardBill (time period 6.1-8.28), cardReport (time period 2.18.28)

If extraction based on time is not supported, full data can be extracted.

Use the mongo client command to enter the database:

Jsfkrs0:PRIMARY > show dbs

2018-09-04T17:35:57.692+0800 E QUERY [thread1] Error: listDatabases failed: {

"ok": 0

"errmsg": "not authorized on admin to execute command {listDatabases: 1.0}"

"code": 13

"codeName": "Unauthorized"

}: _ getErrorWithCode@src/mongo/shell/utils.js:25:13br/ > _ getErrorWithCode@src/mongo/shell/utils.js:25:13

Br/ > shellHelper.show@src/mongo/shell/utils.js:769:19

Br/ > @ (shellhelp2): 1:1

Jsfkrs0:PRIMARY > use admin

Switched to db admin

Jsfkrs0:PRIMARY > db.auth ('mangoadmin','password')

one

Jsfkrs0:PRIMARY > show dbs

Admin 0.000GB

CashloanDb 96.287GB

Fuf_mgdb 0.765GB

Local 1.280GB

Switch to the db we want to operate

Jsfkrs0:PRIMARY > use cashloanDb

Switched to db cashloanDb

Take a look at the total data of these two sets.

Jsfkrs0:PRIMARY > db.cardBill.count ()

247126

Jsfkrs0:PRIMARY > db.cardReport.count ()

249128

First, let's see if there is a timestamp in this table. Let's take a piece of data. If so, we can export based on this timestamp.

Jsfkrs0:PRIMARY > db.cardBill.findOne ()

{

"_ id": ObjectId ("59e180110cxxxxxx")

"timestamp": NumberLong ("1507950609625")

"taskId": "xxxxxx-b08d-11e7-bf17-xxxxx"

"bill": [{\ "balance\": 47000.00,\ "deposits\": [],\ "bills\": [{\ "installments\": [],\ "bill_id\":\ "d81f1e60-a02d-11e7-a63a-00163e0dfac7\",\ "bill_type\":\ "DONE\",\ "bank_name\":\ "CITIC Bank\",\ "bill_month\":\ "2017-04\",\ "bill_date\":\ "2017-04-14\" \ "payment_due

This timestamp has 13 bits, accurate to milliseconds, and we need to convert it to Unix timestamps when exporting, and it can also be accurate to milliseconds.

Http://tool.chinaz.com/Tools/unixtime.aspx

The normal conversion is only to the second position, only 10 digits. You can add 000 directly to the converted Unix timestamp, or the conversion time can be directly accurate to milliseconds, and then we can use the export tool that comes with MangoDB to export.

Mongoexport-d cashloanDb-c cardBill-uadmin-ppassword-authenticationDatabase "admin"-Q'{"timestamp": {$gte:NumberLong ("1517414400000"), $lte:NumberLong ("1535472000000")}'- o cardBill.json

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.