[blackboar]

I feel most people could benefit how to import Breaches into MongoDB with this one single command (Assuming located in /mnt/data/Pemiblanc_BF/data/ )

% strings * | sed 's/:/,/g'|sed 's/"/DQUOTE/g'|mongoimport -c pemiblanc -d pemiblanc --host myhost --fields email,password --type csv --drop

Why:

- strings => display the file(s) but get rid of binary characters that can hang up "cat"

- sed 's/:/,/g'|sed 's/"/DQUOTE/g' => gets rid of the colon punctuation to be of type CSV

- mongoimport -c pemiblanc -d pemiblanc --host myhost --fields email,password --type csv --drop

Then once in MongoDB
% mongo --host myhost

Opening MongoDB
>> use pemiblanc
>> db.pemiblanc.find()
>> db.pemiblanc.createIndex({email:1})

Now you can query from the MongoDB client OR have ChatGPT/Microsoft Edge write you python/perl code to query every collection you have

[shaima-hadi]

thanks appreciate it