How to take backup based on ISODate or ObjectID using mongodump v4.2.2?

[Prasad_Saya]

@hari_dba

2. queryFile wise:

mongodump --port 27019 --db pms --collection purchase --queryFile “{”_id":{“$gte”:{“$oid”:“5e461d06dba04739ea454892”}}}" --out D:\backup_export\admin\admin\ –gzip
2020-03-03T15:47:53.961+0530 Failed: error reading queryFile: open {“_id”:{“$gte”:{“$oid”:“5e461d06dba04739ea454892”}}}: The filename, directory name, or volume label syntax is incorrect.

In your query:

mongodump --port 27019 --db pms --collection purchase --queryFile “{”_id":{"$gte":{"$oid":“5e461d06dba04739ea454892”}}}" --out D:\backup_export\admin\admin\ --gzip

You are using the --queryFile option. But, you have the query instead of the file name. So the error. Change the --queryFile to --query.

@hari_dba

1. date wise:
   D:\bin>mongodump --port 27019 --db pms --collection purchase --query “{“dt”:{”$gte":{“$date”:“2020-02-12T04:07:34Z”}}}" --out D:\backup_export\admin\admin
   2020-03-03T16:19:00.483+0530 writing pms.purchase to
   2020-03-03T16:19:00.527+0530 done dumping pms.purchase (0 documents)

Since there is no error in this case, the issue must be with the query criteria and the available data in the collection. Also, the type of quotes you are using might be the problem; use straight quotes " " instead of “ ”.