Mongodump last 10 day data

[NP_User (NP)]

I want to do backup of last 10 days data only based on my column LastModifiyDate in mongo.

mongodump --gzip --db=mongo-database --collection=Records --out=F:\backup\ --query ‘{LastModifyDate: {$gt: ISODate(‘2021-07-15T07:00:00.000Z’)}}’

Error Received:

Error: 2021-07-26T10:58:40.893-0700 positional arguments not allowed: [{$gt: ISODate(‘2021-07-15T07:00:00.000Z’)}}’]
2021-07-26T10:58:40.895-0700 try ‘mongodump --help’ for more information

[Prasad_Saya]

Hello @NP_User, It is possible that you are not using proper syntax in specifying the query option. This following post has the solution for a similar question:

Mongodump --query not able to filter using timestamp

mongodump --host=“rs0/localhost:27017,localhost:27018,localhost:27019” --readPreference=secondary -d local -c oplog.rs --query="{“ts”:{"$gte":"$Timestamp(0000000000,50)"}}" -vvv -o /home/anupama/backupec2 I am getting output writing local.oplog.rs to 2020-03-29T08:37:08.134+0530 not counting query on local.oplog.rs 2020-03-29T08:37:08.328+0530 done dumping local.oplog.rs (0 documents) 2020-03-29T08:37:08.328+0530 ending dump routine with id=0, no more work to do 2020-03-29T08:37:…

Also, see the example usage of query option in the documentation:

mongodump — MongoDB Database Tools

[Mark_Rozovsky]

Mongodump --query not able to filter using timestamp

A bit late but managed to query using shell date like this –query “{“TABLENAME”:{”$gt":{"$date":"date -v-1H +"%Y-%m-%dT%H:%M:%S%z""}}}" where “1H” stands for an hour, “1d” for days